Hi

When we execute Query DELETE FROM EMP - is going to delete all the rows(DATA). But Structure Remains Same(Structure will not be effacted).

when we execute Query SELECT * FROM EMP -is going to Show the structure.or 0 row(s) affected .

Thank you.

in 1st session

if we fire delete query and in 2nd session if we fire select query then its going to show all the records bcoz after 1st we havent fired commit statement may be i m wrong

Delete is a DML statement so there is no auto commit for delete.

TO answer the question.

Session 1

DELETE FROM EMP;

session 2

SELECT * FROM EMP;

No rows found.

Session 1

Rollback;

Session 2

SELECT * FROM EMP;

12 rows selected.

WHEN WE SAY DELETE FROM EMP; (say) ALL ROWS WILL BE DELETED AND THEN IF WE SAY SELECT * FROM EMP THEN WE GET NO ROWS SELECTED AS THE TABLE DOESN'T CONTAIN ANY DATA.

AFTER ENTERING THE DELETE COMMAND IF WE SAY ROLLBACK THEN ROLLBACK IS DONE AND NOW IF WE SAY SELECT * FROM EMP NOW ALL ROWS WILL BE DISPLAYED . HOPE U GOT THE ANSWER .

ANYWAY PLZ USERS IF U ARE CONFIDENT OF ANSWERS THEN ONLY POST THE SAME AS LITTLE KNOWLEDGE IS DANGEROUS AS UR JEOPARDING THE LIFE OF THE PEOPLE WHO ARE NEW TO ORACLE OR U HAVE CHANGED THEIR BACKGROUND TO IT PLZ CONFIRM IT OR IF UR SURE THEN POST UR ANSWERS.

THANK YOU

HI dwh Professional

In the question...they have given 2 Statements.Thtz it then din't asked any if statements or allowed to use any other Statement.

They simply asked the result...So this result of those two Queries is We are not going to find any data Except the Sturcture .

Don't comment on others View.

Thank you

-Nanditha