1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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

How many types of cursors are available in pl/sql?

586

What is the life of an sql statement?

525

What is data control language?

532

how to drop an existing view in mysql? : Sql dba

570

How can I tell if sql is running?

586




What is normalization in a database?

612

what is a trigger in mysql? Define different types of trigger. : Sql dba

552

How do I pipe the output of one isql to another?

532

What is view explain with example?

519

Is sql a case sensitive language?

516

What is the use of non clustered index?

528

Is mariadb nosql?

586

What is pl sql in dbms?

508

what is rdbms? : Sql dba

581

What is difference between rank () row_number () and dense_rank () in sql?

579