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)

How to define a sub function?

0 Answers  

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 Answers  

Explain the use of indexes option in exp command.

0 Answers  

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

Explain a data segment?

0 Answers  

How to rebuild an index in oracle?

0 Answers  

How to view the data files in the current database?

0 Answers  

Which environment variables are absolutely critical in order to run the OUI?

0 Answers  

How to check the oracle tns settings?

0 Answers  

Explain table?

0 Answers  

What is SQL access advisor in Oracle?

0 Answers   MCN Solutions,

Define Normalization with example?

1 Answers