Interested to Buy Any Domain ? << Click Here >> for more details...
how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 13847 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / hannan oca
delete from tablename; will remove all records but we can
rollback these values.
truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is pl sql useful?
What is procedure and function?
How do I view a view in sql?
Is postgresql a server?
what is the difference between clustered and non clustered index in sql? : Sql dba
Cite the differences between execution of triggers and stored procedures?
How do I view output in sql developer?
What are the advantages of indexing?
Is it possible to sort a column using a column alias?
How does left join work in sql?
What is rank dense_rank and partition in sql?
what is try_catch block in procedure
How do you determine the current isolation level? : Transact sql
What are different types of sql commands?
what is table? : Sql dba
