Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57910 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / vinay dixit
Oracle search for this table in the database and returns
all the rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How do you modify a table in sql?
Is a foreign key always unique?
Write a query to find the names of users that begin with "um" in sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
Why do we use view in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is stored procedure faster than query?
How do you modify a trigger?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is oracle sql called?
what is a field in a database ? : Sql dba
what is a relationship and what are they? : Sql dba
Explian rowid, rownum?
Difference between truncate, delete and drop commands?
