how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
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
what is heap table? : Sql dba
What is the use of index in hive?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is pl sql package?
What is sap sql anywhere?
How can you create an empty table from an existing table?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
Explain isolation levels. : Transact sql
What is database sql?
How can I delete duplicate rows?
Explain how to use transactions efficiently : transact sql
What is the use of double ampersand (&&) in sql queries? Give an example
How do I order by ascending in sql?
What are sql ddl commands?
Why is %isopen always false for an implicit cursor?