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
8072 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

Please explain compound trigger in oracle?

1039

How to create a stored program unit?

1194

What is the database name in oracle?

1003

Can we write insert statement in function in oracle?

1070

What is oracle server autotrace in oracle?

1144

How to view all columns in an existing table?

918

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2168

How to count duplicated values in a column in oracle?

1023

What is a cursor and what are the steps need to be taken?

1185

How do I call oracle stored procedures that take no parameters?

1088

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1954

What is a Garbage Collection? and what is full recursive Garbage collection?

2884

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

1844

Why should I use oracle database?

976

How to create a stored function in oracle?

1093