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’);

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

when MSQL8.0 is in market

0 Answers  

What is clustered index in sql?

0 Answers  

What is difference between pls_integer and integer?

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

what are all different types of collation sensitivity? : Sql dba

0 Answers  

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

Does db2 use sql?

0 Answers  

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

What does := mean in pl sql?

0 Answers  

Can we rollback delete command?

0 Answers