how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 11649 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
How do you write an inner join query?
differentiate between float and double. : Sql dba
Can I learn sql in a week?
Can a view be mutating? If yes, then how?
What is pl/sql table? Why it is used?
How do you explain an index number?
What is group by in sql?
What is the reports view in oracle sql developer?
discuss about myisam key cache. : Sql dba
How delete a row in sql?
Can we insert data in view?
How much ram can sql express use?
what are the security recommendations while using mysql? : Sql dba
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
