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

Does view contain data?

1041

Can we join tables without foreign key?

968

Is pl sql better than sql?

1046

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1067

What is the basic form of sql query?

953

How many types of cursors supported in pl/sql?

1199

Explain isolation levels. : Transact sql

1079

Which tcp/ip port does sql server run?

1020

What is sqlcontext?

1091

Can a trigger call a stored procedure?

1079

What is dbo in sql?

981

How do you create a unique index?

1053

Can you upgrade sql express to full sql?

1082

How exception is different from error?

1028

What is a heap in sql?

1079