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

Answer Posted / dharmendra

select to_char(sysdate,'DD/MON/YYYY') from dual;

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the quickest way to fetch the data from a table?

677


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

2558


How to rename an index in oracle?

698


How to specify default values in insert statement using oracle?

672


How to load data from external tables to regular tables?

629






How to calculate date and time differences in oracle?

626


Explain the use of inctype option in exp command.

673


How do you tell what your machine name is and what is its IP address?

1590


How to use "out" parameter properly?

729


How to convert character types to numeric types?

666


what are the default admin accounts in Oracle 10g ?

585


What are the differences between lov and list item?

642


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1937


What is an anonymous block?

723


What is sharded cluster?

611