Whatz the main diff between Subquery and a Join
Answer Posted / gomolemo kasale
a sub query is a query nested within another query while
join select rows from multiple table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
State any two functions of oracle?
Explain the use of record length option in exp command.
Use of an integrity constraint is better to validate data. Explain
Is java required for oracle client?
Explain the use of file option in exp command.
What is oracle data type?
What is a partition in oracle?
What are the uses of a database trigger?
How to speed up webrick?
What is data block in Oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what are the default admin accounts in Oracle 10g ?
What is a cursor and what are the steps need to be taken?
How to convert numbers to characters in oracle?
Explain an exception and its types?