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 is a partition in oracle?

0 Answers  

What is Index Cluster ?

2 Answers  

What is the use of Redo Log Information ?

2 Answers  

How do you store pictures in a database?

0 Answers  

What is the function of Redo Log ?

1 Answers  

What does a Control file Contain ?

2 Answers  

Difference between hot backup vs. Cold backup?

0 Answers  

What is transport network substrate (tns) in oracle?

0 Answers  

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

what is a Nested Loop join?

0 Answers  

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,