Difference between sub query and nested query ?
Answer Posted / nirvaya
A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What are the different types of database objects?
What is system tablespace?
Differentiate between translate and replace?
How to define an oracle sub procedure?
What is the difference between primary key and unique key and foreign key in oracle?
What are the different types of partitions in oracle?
what is a Nested Loop join?
List out the types of joins.
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How data locks are respected in oracle?
what is the scripts in data base?
What is index in Oracle?
Write a trigger example in oracle?
Difference between pre-select and pre-query
Explain cascading triggers.