When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50433 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
Does inner join return duplicate rows?
What is cartesian join in sql?
What is the difference between delete and truncate commands?
What are the three forms of normalization?
What is a record in pl/sql?
What is java sql connection?
what is bcp? When does it used? : Sql dba
What are pl sql data types?
What is the difference between inner join and left join?
What is pivot table in sql?
Does pl/sql support create command?
What does varchar include?
how to use case expression? : Sql dba
Can we create view in stored procedure?
what is the difference between nested subquery and correlated subquery?
