26. Display the earliest shipping date in the format:
DD/MON/YYYY
Answer Posted / nazim
select convert(char(12),getdate(),106)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to define a specific record type?
How do I manually create a database in oracle?
What is oracle and what are its different editions?
Explain oracle’s system global area (sga).
Can we store pictures in the database and if so, how it can be done?
What is flashback in Oracle?
what happened to the global index when I truncate the data in one of the partition?
What is background process in Oracle?
What is a sub query? Describe its types?
What is Virtual Private Database in Oracle?
How does Oracle guarantee data integrity of data changes?
What is set verify off in oracle?
What is using clause and give example?
What is a system tablespace and when it is created?
Can we write insert statement in function in oracle?