sql文的限制

9i
The maximum size of a sql statement is 64K.

10g
There is no limit on the maximum number of columns in a select list.
The maximum size of a sql statement depends on on many factors, including database configuration, disk space, and memory. But the formula is not open to public(The official voice of ORACLE), so it's better to have a test before using long select statement.