how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 12580 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / krishna kum ar
delete <table_name> --------This removes only the records
not a tablespace
but
truncate <table_name>--------This removes both records as
well as tablespaces in database
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain what is table in a database?
What is pl sql code?
Is stored procedure faster than query?
Which data type is a composite type?
What is the use of %rowtype?
What operators deal with null?
what are the different functions in sorting an array? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
How does sql store data?
What is dml with example?
What are sql*plus environment variables?
What is the process of copying data from table a to table b?
What is the use of sql trace?
How many subqueries can be nested in a statement?
what are all the common sql function? : Sql dba
