select to_char(sysdate,'DD/MON/YYYY') from dual;

26. Display the earliest shipping date in the format:
DD/MON/YYYY

Question Posted / dharmendra

Answer Posted / dharmendra

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

543

How to define a procedure inside another procedure?

539

Explain the characteristics of oracle dba?

632

How to add a new column to an existing table in oracle?

578

How to call a sub procedure?

559

Explain overloading. Can functions be overloaded?

566

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1554

What is merge statement used for?

561

What are the different editions of oracle?

586

What is the use of file param in imp command?

640

Why is oracle used?

549

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1819

what are the default admin accounts in Oracle 10g ?

503

How to export data to a csv file?

615

How to convert character types to numeric types?

568