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

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

Question Posted / dharmendra

5 Answers
7932 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / dharmendra

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

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is rowid unique in oracle?

938

How to set up autotrace for a user account?

972

Why do you create or replace procedures rather that drop and recreate.

945

Explain the use of Merge statement in oracle 11g

975

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2396

What is a proxy object?

1008

What is the disadvantage of User defind function?

2238

What is not equal to in oracle?

951

What suggestions do you have to reduce the network traffic?

899

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4292

How to rebuild an index in oracle?

968

What is Undo Management Advisor in Oracle?

1040

Name the various constraints used in oracle?

969

What is Redo Log Buffer in Oracle?

1122

How to get maxsal , minsal, ename department wise in single query

1499