Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33907 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / srijina
join combines tables and retrieves data where as sub query
doesn't combines two table.join is more faster than subquery
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to pass parameters to procedures?
What is a snapshot in oracle database?
Explain about your project and its relation to the current job position you are applying to?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the use of aggregate functions in oracle?
What is an oracle user role?
How to write an inner join with the where clause in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain the use of file option in exp command.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What are the uses of a database trigger?
Can we store pictures in the database and if so, how it can be done?
What is an Oracle Instance?
