how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 12582 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is blob? : Sql dba
Explain polymorphism in pl/sql.
What are the types of variables use in pl sql?
What is meant by temporal data?
What is sqlca in powerbuilder?
Is pl sql a scripting language?
What is the use of %rowtype?
How do you remove duplicates without using distinct in sql?
What are the parameter modes supported by pl/sql?
What is input buffer in sql*plus?
What are all the different normalization?
Why do we need a foreign key?
How many types of cursors supported in pl/sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What are the differences between implicit and explicit cursors?
