restriction on the number of columns in select statement.

From: <Murali_Pavuloori/Claritas_at_claritas.com>
Date: Tue, 16 Sep 2003 09:29:36 -0800
Message-ID: <F001.005D0106.20030916092936@fatcity.com>

Can someone tell me the restriction on the # of columns in the select clause of the statement.. We are running into sort key too long - ORA-01467. I am told there is no order by or group by in the query. I need to look @ the query to make sure there are no references in the statement that generates a implicit sort. I tried to search on the restriction and could not comeup with anything.

Thanks for your help

Murali.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Murali_Pavuloori/Claritas_at_claritas.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 16 2003 - 12:29:36 CDT