Answer / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Answer / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Answer / dipti

select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)

Answer / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Answer / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Answer / sowmya

Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);

What are the disadvantages of not performing database normalization?

0 Answers  

What are the cursor attributes used in PL/SQL ?

4 Answers  

What is pl sql script?

0 Answers  

what are the security recommendations while using mysql? : Sql dba

0 Answers  

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

How to write a query to show the details of a student from students table whose

0 Answers  

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

Write the command to remove all players named sachin from the players table.

0 Answers  

How to recompile a already made trigger?

2 Answers  

What is use of package in pl sql?

0 Answers  

Explain what is sql*plus?

0 Answers