When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53602 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
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
Are dml statements autocommit?
Can we insert delete data in view?
Does truncate require commit?
Does sql backup shrink transaction log?
How do I run a query in pl sql developer?
What are triggers and its types?
What are tables and fields in the database?
What is oracle pl sql developer?
What is the starting oracle error number?
How do I kill a query in postgresql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is sqlite thread safe?
Explain the difference in execution of triggers and stored procedures?
How do I start sql profiler?
What is the primary key?
