When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53643 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
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
Is it mandatory for the primary key to be given a value when a new record is inserted?
what is transaction? : Sql dba
What is the difference between joins?
What do you mean by field in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
explain advantages of innodb over myisam. : Sql dba
What is difference between cursor and trigger?
Is id a reserved word in sql?
What is on delete set null?
What does count (*) do in sql?
Can you load data into multiple tables at once? : aql loader
Can dml statements be used in pl/sql?
What is the plv (pl/vision) package offers?
How to add new employee details in an employee_details table with the following details
How many types of functions are there in sql?
