Re: [SQL] Max Columns in a SQL Select

2004-05-17 Thread Richard Huxton
PS PS wrote: SQL Guru's, Does anyone know what is the Column Limit in a SQL Query in Oracle RDB version 7.1? I've about 200 columns in my SQL query. Each column is a computed column -- Case when a = b Then c Else 0 End. You'll probably want an Oracle mailing list - this is for PostgreSQL. --

[SQL] Max Columns in a SQL Select

2004-05-17 Thread PS PS
SQL Guru's, Does anyone know what is the Column Limit in a SQL Query in Oracle RDB version 7.1? I've about 200 columns in my SQL query. Each column is a computed column -- Case when a = b Then c Else 0 End. It gives me a runtime error -- abnormal program termination -- upon execution. Than