Data Access Question: Download Oracle Data Access PDF
Explain Can we delete tuples in a table based on date column? And how?
Answer:
Use this SQL query :delete from student_tab A where ROWID > ( select min(ROWID) from student_tab B where A.roll_number = B.roll_number);Note : Table Name = student_tab Key to table = roll_number
Yes ,, we can delete entries from a table based on the date column,,Only we have to mention the date format or other wise we'll have to make use of the sys date.
Yes ,, we can delete entries from a table based on the date column,,Only we have to mention the date format or other wise we'll have to make use of the sys date.