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


Please Help Members By Posting Answers For Below Questions

Write a query to display the current date in sql?

504


how to check myisam tables for errors? : Sql dba

586


Which sql statement is used to return only different values?

495


How do I filter in sql profiler?

528


How do you update a sql procedure?

515






What are the packages in pl sql?

564


Why is pl sql used?

520


What is denormalization in a database?

584


Which operator is used in query for pattern matching?

616


Explian rowid, rownum?

556


How do I save a sql query?

537


Explain the commit statement.

604


What is index example?

546


Can we rollback truncate?

531


What will you get by the cursor attribute sql%rowcount?

545