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 are the types of join and explain each? : Sql dba
What is the use of triggers?
What are the two types of cursors in pl sql?
What is the example of procedure?
What are procedures used for?
Mention what pl/sql package consists of?
What are the built in functions of sql?
How is indexing done in search engines?
What does desc stand for?
What are the sql versions?
How can you load multi line records? : aql loader
How many parts of a pl sql block are optional?
What is not null in sql?
What are schema-level triggers?
What are the types of functions in sql?