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
15507 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 is pls integer?

983

How many types of keys are there in sql?

986

Explain table and field in sql?

1015

explain advantages of myisam over innodb? : Sql dba

1015

Why is sql important?

1026

Can we use the cursor's to create the collection in PL/SQL?

959

Do foreign keys improve performance?

965

What is the use of triggers?

978

What are pl sql data types?

954

How do you update sql?

912

Why do we use procedures in pl sql?

961

Which are the different types of indexes in sql?

990

Define the select into statement.

992

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114

What is forward declaration in pl sql?

1005