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
15840 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

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4289

What does stand for in sql?

973

What is a string data type in sql?

1045

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1155

Why triggers are used?

990

What is sql select statement?

1035

How to use distinct and count in sql query? Explain

1025

What is PL/SQL Records?

1191

What is composite data type in pl sql?

1114

How do I run a pl sql program?

1130

What is mutating trigger?

1024

What is schema in sql?

950

How do I restart sql?

976

Is oracle and sql same?

1013

What is scalar function?

1054