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


Please Help Members By Posting Answers For Below Questions

What are all types of user defined functions?

535


What is the difference between view and stored procedure?

499


What is procedure and function in sql?

541


What is number function in sql?

538


Can we use having without group by in sql?

559






How do I know if I have sql express or standard?

614


Why do we use partitions in sql?

549


What is a behavioral trigger?

523


Why do we use subquery?

496


What is use of package in pl sql?

543


what is view? : Sql dba

563


What are different types of indexes?

518


What is sql exception?

531


What is the main reason behind using an index?

562


What is sql catalog?

578