select * from emp
what happened internally when we write this query in the sql
prompt?
Answer Posted / dinesh chandra
it will display all the records of emp table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the blob datatype?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is meant by a deadlock situation?
What is the relation of a user account and a schema in oracle?
What is a view and how is it different from a table?
how to clone 9i Database on to 10g Database.
How to revoke create session privilege from a user in oracle?
How many memory layers are in the oracle shared pool?
What is control file used for?
What is the difference between postgresql and oracle?
How to export data with a field delimiter?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How would you change old and new values in an insert, delete and update triggers?
How to create a stored program unit?
How can you use check constraints for self referential integrity?