how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / rupesh
Mr. Krishna Kumar
With truncate rows will delete as well as tablespace not.
instead of tablespace you have to use physical memory space.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain primary keys and auto increment fields in mysql : sql dba
What is an index in sql with example?
List the ways to get the count of records in a table?
How do I run a program in pl sql?
how to shut down the server with 'mysqladmin'? : Sql dba
What is the purpose of the sql select top clause?
What is the use of triggers?
What is bulk collect in pl sql?
What is database white box testing and black box testing?
How to order siblings in oracle hierarchy queries?
What is the difference between in and between in sql?
How to pronounce postgresql?
what is dbms? : Sql dba
What is scalar function?
What is indexing oracle sql?