select * from TABLE1 where VSIZE(column

wirte a query to filter improper date format follwing table?
date
20-apr
22-may-2010
26-jun-2010
feb-2009

i want the output

date
22-may-2010
26-jun-2010

Question Posted / dipti

6 Answers
15761 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / dipti

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different methods to trace the pl/sql code?

1094

How do you drop a trigger?

968

what is a cursor? : Sql dba

1003

What is nosql vs sql?

1158

what is meant by urlencode and urldocode? : Sql dba

1155

What are the types of variable use in pl sql?

1056

Why does sql need a server?

1020

How to get each name only once from an employee table?

1097

What does the argument [or replace] do?

1065

How do you modify a table in sql?

1107

what is the different between now() and current_date()? : Sql dba

995

Explain the purpose of %type and %rowtype data types?

906

Are views faster than queries?

978

How to create your own reports in sql developer?

1006

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

985