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
- 14184 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
what are different types of keys in sql?
What is mutating table error?
How do rank () and dense_rank () differ?
Can we write dml inside a function in sql server?
how to write date and time literals? : Sql dba
what is normalization? : Sql dba
How many columns should be in an index?
explain the difference between bool, tinyint and bit. : Sql dba
explain advantages of myisam over innodb? : Sql dba
What does seeding a database mean?
How many types of privileges are available in sql?
What is coalesce in sql?
Why do we create views in sql?
What is pl sql code?
How do I pipe the output of one isql to another?
