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 a file delimiter?

1162

explain commit and rollback in mysql : sql dba

1073

Why do we need databases?

1085

how to use case expression? : Sql dba

1078

Is left join same as inner join?

1215

Are pl sql variables case sensitive?

1091

How do I edit a stored procedure?

1046

Can %notfound return null after a fetch?

1101

Is subquery faster than join?

1063

What is $$ in sql?

1042

Can sql developer connect to db2?

1102

who introduced sql?

1071

Name the operator which is used in the query for pattern matching?

1004

Can we use the cursor's to create the collection in PL/SQL?

1092

what is isam? : Sql dba

1065