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

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

Question Posted / bhanu

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

Answer Posted / bhanu

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you understand by a database object? Can you list a few of them?

1002

What is tns name?

963

What is blob datatype?

1100

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2195

Explain do view contain data?

986

How to resolve name conflicts between variables and columns?

1005

What is oracle sid?

939

Explain constraining triggers.

1069

Â What are the oracle DML commands possible through an update strategy?

1042

How to install oracle odbc drivers?

1076

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2447

State any two functions of oracle?

1024

How will you write a query to get a 5th rank student from a table student_report?

1844

What is merge in oracle?

1034

Explain the use of owner option in exp command.

1028