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 can I see all tables in sql?
how does a local variable is defined using t-sql? : Transact sql
What is multiple columns?
what is the difference between union and union all? : Sql dba
What are the disadvantages of file system?
What are tables and fields in the database?
What is a recursive stored procedure?
What are transaction and its controls?
how do you login to mysql using unix shell? : Sql dba
What does dml mean?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Is sql microsoft?
What is the maximum number of columns in sql table?
Explian rowid, rownum? What are the psoducolumns we have?
How exception handling is done in advance pl/sql?