When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53603 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / geetha priya
It will retrieve all the columns of emp table. There is no
need to check for conditions as there are no conditions
specified in the given command.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain architecture of sql server notification services?
how to get a list of all tables in a database? : Sql dba
What is the difference between left join and right join?
how to rename an existing column in a table? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
Can we call stored procedure in function?
What is the difference between inner join and natural join?
Can I learn sql in a week?
Why do we need view in sql?
Can we use join in subquery?
Who developed sql?
What is the use of triggers?
What is %type in sql?
What types of commands can be executed in sql*plus?
What are the three pl sql block types?
