When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / babapps
hi
we enter this query then oracle engine takes this query and
to search particular given table in database table then
select command act as a cursor to retrieve the data or to
fetched the
data from database table then to print the data on sql prompt
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to get list of all tables from a database?
what is a constraint? Tell me about its various levels. : Sql dba
How do you use a while loop in pl sql?
Can we write ddl statements in functions?
what is try_catch block in procedure
What is prepared statement in sql?
Is sql pronounced sequel or sql?
What is t-sql? : Transact sql
What are stored procedures in mysql?
what tools available for managing mysql server? : Sql dba
What are the advantages of normalization?
define join and explain different type of joins? : Sql dba
What is data type in sql?
What is sql*loader?
Is left join same as join?