Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56933 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
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
How do I view an execution plan in sql?
What is record type in pl sql?
What is union and union all keyword in sql and what are their differences?
Explain autonomous transaction.
What information is needed to connect sql*plus an oracle server?
Why indexing is needed?
Mention what plvcmt and plvrb does in pl/sql?
Can we create clustered index without primary key?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Explain the uses of database trigger.
How do I view output in sql developer?
What is a natural join sql?
what is subquery? : Sql dba
what is user defined functions? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
