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

Show the two pl/sql cursor exceptions.

0 Answers  

How do you explain an index?

0 Answers  

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

What are database links used for?

0 Answers  

What is field delimiter?

0 Answers  

Explain cursor types?

0 Answers  

Explain the steps needed to create the scheduled job?

0 Answers  

Explain mutating table error.

0 Answers  

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

How to set up sql*plus output format in oracle?

0 Answers  

What does (*) mean in sql?

0 Answers