Whatz the main diff between Subquery and a Join
Answer Posted / rajesh
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
| Is This Answer Correct ? | 78 Yes | 27 No |
Post New Answer View All Answers
Can you create a synonym without having a table?
What is where clause in oracle?
How to insert a record into a table?
What is Trigger in Oracle?
What is a relational database management system?
How many data types are supported?
How to create a temporary table in oracle?
WHAT IS ecc 6.0
How to define a procedure inside another procedure?
How to create a testing table in oracle?
What is the data type of dual table?
How to delete a column in an existing table?
What is a procedure in oracle?
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
Whether any commands are used for months calculation? If so, what are they?