how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
What is AUTH_ID and AUTH_USER in pl/sql ?
Can a commit statement be executed as part of a trigger?
what are the type of locks ? : Sql dba
Can you upgrade sql express to full sql?
How does stored procedure reduce network traffic?
What is range partitioning?
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
define sql insert statement ? : Sql dba
Does google use sql?
how to select first 5 records from a table? : Sql dba