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
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
What are different methods to trace the pl/sql code?
How do you drop a trigger?
what is a cursor? : Sql dba
What is nosql vs sql?
what is meant by urlencode and urldocode? : Sql dba
What are the types of variable use in pl sql?
Why does sql need a server?
How to get each name only once from an employee table?
What does the argument [or replace] do?
How do you modify a table in sql?
what is the different between now() and current_date()? : Sql dba
Explain the purpose of %type and %rowtype data types?
Are views faster than queries?
How to create your own reports in sql developer?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba