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
How many joins in sql?
what is msql? : Sql dba
What trigger means?
Do we need to create index on primary key?
how can you create an empty table from an existing table? : Sql dba
What is dense_rank in sql?
What are the advantages of normalization?
Are dml statements autocommit?
what are the types of subquery? : Sql dba
What is oracle sql developer?
What is self-join and what is the requirement of self-join?
what are aggregate and scalar functions? : Sql dba
What is the use of & in pl sql?
What is multiple partition?
What are procedures used for?