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
What are the different editions of oracle?
What is a nested table?
What is ordinary table in oracle?
What are the tools for Oracle ?
How to call a stored function with parameters?
Which is faster join or subquery in oracle?
What is a snapshot in oracle database?
definition of cluster and non-clustered index?
Explain the use of rows option in imp command.
Is truncate autocommit in oracle?
How do I know if oracle is installed on windows?
What are dml statements in oracle?
Explain the use of consistent option in exp command.
How to open a cursor variable?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?