select convert(char(12),getdate(),106)

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

Question Posted / nazim

Answer Posted / nazim

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Please explain oracle left join with an example?

576

How do I start tns listener?

530

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1664

How can we create the complete backup of data in the oracle.

1680

What is the usage of control file in oracle?

599

How to create an initialization parameter file?

535

How can Oracle users be audited?

600

What are oracle functions?

544

What are the limitations oracle database 10g xe?

565

What is data type in oracle?

556

Why do you use stored procedures and state some of its disadvantages?

556

What is a table index in oracle?

623

What is oracle datasource?

541

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2444

why dont we assign not null constraint as table level constraint.

2247