select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy

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

Question Posted / uday shankar chejerla

Answer Posted / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a nested table and how is it different from a normal table?

662

What is save point in oracle database?

838

What is execute immediate in oracle?

627

What is a tns service name?

616

What do you understand by database schema and what does it hold?

759

What is a initialization parameter file in oracle?

657

What privilege is needed for a user to connect to oracle server?

640

Explain the use of ignore option in imp command.

657

What is the difference between PFILE and SPFILE in Oracle?

653

Explain the use of log option in exp command.

616

How to retrieve values from data fields in record variables?

656

What are the attributes of the cursor?

642

What is the difference between view and materialized view in Oracle?

712

Can group functions be used in the order by clause in oracle?

659

What is raw datatype in oracle?

667