Whatz the main diff between Subquery and a Join
- 14 Answers
- 31004 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suramya biswas
Sub Query can be used for UPDATE,DELETE statements where as
Join Query is only used in SELECT statement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
material view and view disadvantages?
How to best split csv strings in oracle 9i?
When do you get a .pll extension in oracle? Explain its importance
Explain implicit cursor.
what is reindexing?
What is ADDM Advisor in Oracle?
Can we connect to ORACLE db using Windows Authentication?
How to loop through data rows in the implicit cursor?
How to export your connection information to a file?
How to use values from other tables in update statements using oracle?
How to count groups returned with the group by clause in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How do I know if oracle is installed on windows?
What is a trace file and how is it created in oracle?
Is the After report trigger fired if the report execution fails ?
