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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / sophia

8 Answers
13966 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / kriahna chaitanya

delete From <table>;

Is This Answer Correct ?

22 Yes

4 No

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

Answer / chinna

truncate table <tbl_nm>

Is This Answer Correct ?

14 Yes

7 No

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

Answer / hannan oca

delete from tablename; will remove all records but we can
rollback these values.

truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.

Is This Answer Correct ?

2 Yes

0 No

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

Answer / shekharjchandra

I think people here just answering the questions just for sake of answering. First of all the framing of question is not correct, anyone who knows oracle will know how to delete records from table, just by using Delete from tablename...etc etc

By looking into the question and example by Sophia it looks like she wants to delete the duplicate rows from the table.

Some of you answered correctly like Pratap.

But others are just telling the difference between Delete and Truncate, which is not required in this context at all, I am sure if we answer like this in interviews the interviewer will decide what he wants.

Please don't mind my words, and take it serious and give to the prompt answers, even if u dont know correct answer try to get from other sites, so that when someone looks for such questions they should get correct answer rather they should read all answers for getting correct reply.

Regards
J

Is This Answer Correct ?

2 Yes

0 No

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

Answer / pratap

delete from table name;
or truncate table name;

Is This Answer Correct ?

5 Yes

4 No

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

Answer / 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

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

Answer / krishna kum ar

delete <table_name> --------This removes only the records
not a tablespace

but

truncate <table_name>--------This removes both records as
well as tablespaces in database

Is This Answer Correct ?

2 Yes

3 No

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

Answer / pratap

Delete from table name where row_id not in (select min(no)
from table_name group by no)

Is This Answer Correct ?

2 Yes

6 No

Post New Answer