how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 12573 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
How to rename a column in the output of sql query?
What schema means?
what is the difference between cluster and non cluster index? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
What is data definition language?
what is query cache in mysql? : Sql dba
What is the life of an sql statement?
What is foreign key sql?
what is collation? : Sql dba
What is a relationship and what are they?
what is unique key constraint? : Sql dba
how to create a new view in mysql? : Sql dba
How does an execution block start and end in pl sql?
Is progress software supports to ( pl/sql )?
Which version of sql do I have?
