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
What is the difference between Union and Union all. Which is faster.
What are few of the schema objects that are created using PL/SQL?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Which is better trigger or stored procedure?
Which command is used to delete a trigger?
What does <> sql mean?
how many columns can be used for creating index? : Sql dba
how many ways to get the current time? : Sql dba
Why we use join in sql?
what is column? : Sql dba
Is sqlexception checked or unchecked?
What is scalar and vector?
what are the differences among rownum, rank and dense_rank? : Sql dba
What are field types?
What is cursor explain with example?