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 / john bershan
select to_char(column_name,'dd-mon-yyyy') from <table_name>;
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is primary key and foreign key with example?
What are sql queries used for?
Explain what is rdbms?
What is the plv (pl/vision) package offers?
How do you modify a table in sql?
What are triggers in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What are local and global variables and their differences?
does sql support programming? : Sql dba
What is coalesce in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can a key be both primary and foreign?
What is normalization? How many normalization forms are there?
Show the cursor attributes of pl/sql.
What is the difference between Union and Union all. Which is faster.