26. Display the earliest shipping date in the format:
DD/MON/YYYY
Answers were Sorted based on User's Feedback
select to_char(sysdate,'DD/MON/YYYY') from dual;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / uday shankar chejerla
select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;
Is This Answer Correct ? | 3 Yes | 2 No |
What does `(+)` do in a where clause?
What is meant by raw datatype?
what are archived logs?
what is insert all statement in sql
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
What are the different oracle database objects?
What are named parameters?
How to create a single index for multiple columns?
What is the dynamic sql in oracle?
26. Display the earliest shipping date in the format: DD/MON/YYYY
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Describe Referential Integrity ?