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 is the limitation on the block size of pl/sql?

0 Answers  

Why do we use procedures?

0 Answers  

check whether all the emp numbers are indeed unique.

6 Answers  

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

How can we schedule the procedure to run automatically ?

3 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

how to check myisam tables for errors? : Sql dba

0 Answers  

What are sql indexes?

0 Answers  

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

Why is a trigger used?

0 Answers  

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

What is an example of translating a date into julian format?

0 Answers