Answer / dharmendra

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

Answer / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

Answer / panchi

dd/mm/yyyy

Answer / bhanu

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

Answer / nazim

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

what are different types of deletes?

1 Answers  

How to use null as conditions in oracle?

0 Answers  

Define oracle database

0 Answers  

How to retrieve data from an cursor to a record?

0 Answers  

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

What is a table index in oracle?

0 Answers  

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 Answers  

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

Please explain joins in oracle?

0 Answers  

What is autonomous transaction?

6 Answers  

What is a shared pool?

1 Answers