When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / veni
WE give this query when, we need to view the entire record
of emp table. ( i.e) it will display all the rows and
columns of emp table. and the oracle respond the same as
per the query given.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Difference between truncate, delete and drop commands?
What are different functions in sql?
What is difference between sql and oracle?
What does dml mean?
What is the largest value that can be stored in a byte data field?
what are the different index configurations a table can have? : Sql dba
How you improve the performance of sql*loader? : aql loader
how would you get the current date in mysql? : Sql dba
Do we need commit after truncate?
Which is faster truncate or drop?
What's the difference between inner join and left join?
When is the update_statistics command used?
Can we use pl sql in sql server?
what does the t-sql command ident_current does? : Transact sql
What are hotfixes and patches?