When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50282 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / rahul vishwakarma
When we execute this command then the Oracle engine start
the process and terieve the values and store them in
IMPLICIT CURSOR then the values from this cursor are send
to the user panel
| Is This Answer Correct ? | 27 Yes | 9 No |
Post New Answer View All Answers
Why truncate is used in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is a pdo connection?
What is cursor and why it is required?
Is inner join same as self join?
How subquery works in sql?
How to fetch alternate records from a table?
What is a natural join?
what is try_catch block in procedure
Explain constraints in sql?
what is text? : Sql dba
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is the maximum size of sqlite database?
How can you view the errors encountered in a trigger?
Can a view be mutating? If yes, then how?
