Home » SQL & PL/SQL » SQL & PL/SQL » How many Subqueries can i write?
How many Subqueries can i write? [message #242030] Thu, 31 May 2007 07:49 Go to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

How Many sub queries can I write? please advice me.

Reds
Thangam
Re: How many Subqueries can i write? [message #242036 is a reply to message #242030] Thu, 31 May 2007 08:07 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,


Subqueries


Maximum levels of subqueries in a SQL statement


Unlimited in the FROM clause of the top-level query

255 subqueries in the WHERE clause

here are few links
link1

link2

regards
shanth

[Updated on: Thu, 31 May 2007 08:09]

Report message to a moderator

Previous Topic: Compress pages and the truncate free spaces
Next Topic: control exceptions
Goto Forum:
  


Current Time: Mon Dec 05 23:56:19 CST 2016

Total time taken to generate the page: 0.08686 seconds