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 schema in sql?

511


Is it possible for a table to have more than one foreign key?

582


How do you select unique values in sql?

498


how do you know the version of your mysql server? : Sql dba

503


How do I run a query in pl sql developer?

560






how to use regular expression in pattern match conditions? : Sql dba

522


Does db2 use sql?

508


What is synonyms?

570


What is pragma in sql?

620


How to Declare Fixed Length String Value In PL SQL

659


Is it possible to pass parameters to triggers?

571


What's the procedure?

490


Is and as keyword in pl sql?

511


what is the difference between undefined value and null value? : Sql dba

562


Is it possible to include an insert statement on the same table to which the trigger is assigned?

559