Difference between sub query and nested query ?
Answer Posted / sravzzz
Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.
Is This Answer Correct ? | 12 Yes | 15 No |
Post New Answer View All Answers
How to rollback the current transaction in oracle?
What is the data pump export utility?
What is a data dictionary and how can it be created?
How will you differentiate between varchar & varchar2?
What is a partition in oracle?
Why do you create or replace procedures rather that drop and recreate.
What is the usage of synonyms?
How to create a temporary table in oracle?
Can we create trigger on materialized view in oracle?
How to define an anonymous procedure with variables?
What is user managed backup in Oracle?
Describe the types of sub query?
How to start instance with a minimal initialization parameter file?
What happens to the current transaction if a ddl statement is executed?
How to connect to the server with user account: sys?