what is the main difference between join and subqurey?
- 3 Answers
- 6442 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / udayselva
Subquery returns only one row and Join return More than one rows
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What does pl sql developer do?
Is join an inner join?
Can we commit in trigger?
Can cursors be part of a trigger body?
What are the differences between implicit and explicit cursors?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Name three sql operations that perform a sort.
What does 0 mean in sql?
Is sql scripting language?
What is oracle pl sql developer?
What is the plv (pl/vision) package offers?
Is sql low level language?
how would concatenate strings in mysql? : Sql dba
What can sql server reporting services do?
What is difference between sql and oracle?
