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 to use "in" parameter properly?

1071

How to define an oracle cursor variable?

1027

Explain compound trigger in oracle?

1038

Explain the truncate in oracle?

966

How to pass parameters to procedures?

1034

how to clone 9i Database on to 10g Database.

2338

how can we store any pdf file in oracle

2164

How to install oracle odbc drivers?

1093

What are the different types of failures that occur in Oracle database?

1067

What is oracle join syntax?

1003

What is backup in Oracle?

1004

What is a directory object?

1097

What is background process in Oracle?

1101

What do you mean by a deadlock?

1065

Explain what are clusters?

1108