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
8166 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 are the parameters that we can pass through a stored procedure?

1065

How to create a new table in your schema?

1081

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2028

How does one get the view definition of fixed views/tables?

1022

Can we store images in oracle database?

1010

What happens to the indexes if a table is recovered?

993

How to define an oracle sub procedure?

1146

How to drop an existing view in oracle?

946

What happens if the update subquery returns multiple rows?

1116

How to define an anonymous procedure with variables?

1161

How to rename a tablespace in oracle?

1087

What are the set operators union, union all, minus & intersect meant to do?

989

Describe the types of sub query?

999

What is the implicit cursor in oracle?

1106

How can we find out the duplicate values in an oracle table?

1046