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 difference between cartesian join and cross join?

580

How to divide query output into groups in oracle?

551

What language does oracle use?

590

How can I get column names from a table in oracle?

526

What is ADDM Advisor in Oracle?

652

What is set verify off in oracle?

567

What are the different types of synonyms?

582

What is null value in oracle?

621

Differentiate between post-database commit and post-form commit?

536

What is flashback in Oracle?

576

How to create a table index?

553

How to change program global area (pga) in oracle?

576

What do you mean by merge in oracle and how can you merge two tables?

514

What are the arithmetic operations?

574

What is oracle analytical function?

521