When we give SELECT * FROM EMP; How does oracle respond?
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
How does a covering index work?
What is meant by temporal data?
What is anonymous block in sql?
what is the difference between a local and a global temporary table? : Sql dba
how can we know the number of days between two given dates using mysql? : Sql dba
What is the main reason behind using an index?
Explain the select statement in sql?
What is pl sql block structure?
What is the difference between database trigger and stored procedure?
explain primary keys and auto increment fields in mysql : sql dba
what are the advantages of using stored procedures? : Sql dba
Enlist the data types that can be used in pl/sql?
What are instead of triggers?
how to select unique records from a table? : Sql dba
What is the best partition size for windows 10?