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
- 6 Answers
- 14709 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
How many sql statements are used?
How can triggers be used for the table auditing?
Can you have more than one trigger on a table?
what are the types of subquery? : Sql dba
Why we use triggers in mysql?
What is normalization in a database?
Which one is better sql or oracle?
how to check myisam tables for errors? : Sql dba
Explain dml and ddl?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How to return an array from java to pl/sql?
What are the two parts of design view?
How do I remove sql plus from windows 10?
how to return query output in html format? : Sql dba
Do foreign keys improve performance?
