Re: Maximum number of columns
Date: 2000/02/16
Message-ID: <88dval$179$1_at_nnrp1.deja.com>#1/1
Sonia,
I'm sure there's a limit somewhere, but hope to never need to create
or maintain a table anywhere near it. Have several tables at work with
100+ columns, many with 20 to 50, no problems with any of them. If
there is a fixed limit, I'd assume you would get an error when your
create statement was run. If you are getting 'odd' behavior with a 14
column table, the problem lies elsewhere.
Regards,
Paul
In article <950629212.13918.0.nnrp-02.9e9859ae_at_news.demon.co.uk>,
"Sonia Gillespie" <sonia_gillespie_at_lagan.com> wrote:
> In sql*Plus, is there a maximum number of columns that a table can
have?
> What happens if you go beyond this maximum number?
>
> --
> Sonia Gillespie,
> E-mail: sonia_gillespie_at_lagan.com
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Feb 16 2000 - 00:00:00 CET