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

How to call a stored function with parameters?

1091

How to rename an index?

1122

Is there a function to split a string in plsql?

1106

Can you assign multiple query result rows to a variable?

1035

What is meant by joins? List out the types of joins.

1102

What is a server parameter file in oracle?

1095

What happens to the indexes if a table is recovered?

1045

Name the three major set of files on disk that compose a database in Oracle?

1170

Explain the use of inctype option in exp command.

1080

Differentiate between function and procedure in oracle.

1150

what is Single Byte Overhead...?

2611

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.

1829

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1158

Give the various rollback segment states.

1086

What is pragma autonomous transaction in oracle?

1121