Difference between join and a subquery?
Answer Posted / maddy
Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....
join is used to join the two table is used to retriew the
data from 1 or more tables.....
Is This Answer Correct ? | 27 Yes | 12 No |
Post New Answer View All Answers
List out the difference between commit, rollback, and savepoint?
How to drop an existing view in oracle?
What is an oracle function?
what is the dual table in oracle?
How to update a table row with a record?
Explain about achiever in sql?
Explain constraining triggers.
Calculate difference between 2 date / times in oracle sql?
How to declare a local variable?
Explain drop constraint oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is oracle host variable?
How to create a new user account in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What privilege is needed for a user to connect to oracle server?