Mr. Krishna Kumar With truncate rows will delete as well as tablespace

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Question Posted / rupesh

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

Please Help Members By Posting Answers For Below Questions

Which are the different case manipulation functions in sql?

953

Is stored procedure faster than query?

914

Define SQL and state the differences between SQL and other conventional programming Languages?

1141

what are the different index configurations a table can have? : Sql dba

937

Is sql better than access?

961

Can %notfound return null after a fetch?

999

What are different types of statements supported by sql?

1096

Why do we use procedures?

911

How can you know that statistics should be updated?

1025

Why use truncate instead of delete?

960

What is trigger in pl sql?

955

What is view explain with example?

882

What plvcmt and plvrb does in pl/sql?

1249

difference between anonymous blocks and sub-programs.

1079

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1072