The sql engine select the records from the table EMS and it store in IMPLIC

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / belal ansari

Answer Posted / belal ansari

The sql engine select the records from the table EMS and it store in IMPLICIT CURSOR then display these recordes.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is cursor and why it is required?

1183

Which query operators in sql is used for pattern matching?

966

Why is pl sql needed?

943

what are different types of collation sensitivity? : Sql dba

1065

Can we use ddl statements in stored procedure?

1154

What are the different datatypes available in PL/SQL?

1085

What is the sql query to display the current date?

1044

how can we find the number of rows in a table using mysql? : Sql dba

1083

How to create a menu in sqlplus or pl/sql?

1122

If a cursor is open, how can we find in a pl/sql block?

1167

Can a commit statement be executed as part of a trigger?

1048

How do you identify a primary key?

1063

Is sql similar to python?

973

How does left join work in sql?

1001

How to take user input in pl sql?

1163