i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Subqueries and Use of Subqueries
11-26-2010, 10:40 AM
Post: #1
Subqueries and Use of Subqueries
Describe the types of problem that subqueries can solve
Define subqueries
List the types of subqueries
Write single-row and multiple-row subqueries


This Chapter also deals briefly with the following topics

Using a Subquery to Solve a Problem
Subquery Syntax
Guidelines for Using Subqueries
Types of Subqueries
Single-Row Subqueries
Using Group Functions in a Subquery
The HAVING Clause with Subqueries
Multiple-Row Subqueries
Using the ANY Operator in Multiple-Row Subqueries
Using the ALL Operator in Multiple-Row Subqueries
Null Values in a Subquery




Attached File(s)
.pdf  Les06.pdf (Size: 392.02 KB / Downloads: 6)

Oracle Certified Trainer
[Image: signature.php?uid=40]
Quote
11-26-2010, 11:41 AM
Post: #2
RE: Subqueries and Use of Subqueries
Nice sharing usman..good to see basic concepts again...Keep posting valuable things..

“A mind stretched by a new idea can never go back to its original dimension.”

Quote
11-26-2010, 12:45 PM
Post: #3
RE: Subqueries and Use of Subqueries
Thanks praveen.
Its necessary to revise the basic concept with the passage of time Smile

Oracle Certified Trainer
[Image: signature.php?uid=40]
Quote
12-26-2010, 07:27 AM (This post was last modified: 12-26-2010 07:27 AM by Priya.)
Post: #4
RE: Subqueries and Use of Subqueries
i was looking oracle tutorial... good sharing usman.
can you please upload some basic slides on Oracle Memory Management

Best Regards
Priya
Quote




User(s) browsing this thread: 1 Guest(s)