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

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5406

Explain enable novalidate constraint.

1028

What is save point in oracle database?

1234

What is a cursor variable?

1042

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2295

What is the string concatenation operator in oracle?

1090

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2087

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1692

What happens if you set the sga too low in oracle?

1050

How to define a variable of a specific record type?

1014

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

Differentiate between translate and replace?

1035

What is a tns file?

937

Explain what are the characteristics of data files?

1029