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

What is %rowtype in pl sql?

679


How do I view an execution plan in sql?

709


how to create a new table by selecting rows from another table in mysql? : Sql dba

744


What does count (*) do in sql?

735


explain normalization concept? : Sql dba

785






Can a table contain multiple primary key’s?

801


What is keys and its types?

743


Why is pl sql used?

685


What is sql query limit?

697


What are the uses of merge?

890


What is pivot table in sql?

730


Can you call pl/sql package functions from within a fast formula?

767


What is the process of debugging?

738


What is a native sql query?

697


Does execute immediate commit?

924