When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / suresh
it will check for emp table(available or not).
1.if emp table available then it will retreive all the
colums from emp table..
2.if it is not available then it will give error..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how is myisam table stored? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
Which command is used to call a stored procedure?
what are the 'mysql' command line options? : Sql dba
What is sql deadlock?
What is procedure in pl sql?
Which table is left in left join?
Can we use ddl commands in pl sql?
What is sap sql?
Does truncate free space?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How do you delete duplicates in sql query using rowid?
What is sql and how does it work?
What is the purpose of my sql?
What is trigger in pl sql?