Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum table joins

Status
Not open for further replies.
shyamal

shyamal

Programmer
Aug 14, 2000
79
US
Anyone know what the maximum table joined can be in Oracle 8i\9i?

Thanks in advance.
 
Sort by date Sort by votes

There is actually no limit with the number of tables in a joined SQL statement but for 8 and 8i, the maximum length of statements is 64K maximum, particular tools may impose lower limits.


 
Upvote 0 Downvote
Hi ..
[there should be no limit on the number of tables joined in one sql statement or the number of rows returned] not only in oracle but in any ANSI compatible relational RDBMS ...

I have written one sql statement [DB2] that spans 6 pages of printed A4 papers...yaaaaaaaak ...but again if u join tooooo many tables or may be stitch together mannnny queries with UNION clause , then your application is probably ill designed ...

Salim


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
689
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
589
carp
carp
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
155
carp
carp
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
204
fredericofonseca
fredericofonseca
harfri
  • Locked
  • Question
Insert data from Table A into Table B how can I do that?
Replies
3
Views
198
carp
carp

Part and Inventory Search

Sponsor

Back
Top