Re: number of columns in a table?
From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/08/14
Message-ID: <4utf56$eqi_at_zimmer.CSUFresno.EDU>#1/1
Date: 1996/08/14
Message-ID: <4utf56$eqi_at_zimmer.CSUFresno.EDU>#1/1
In article <3210E4A8.41C6_at_curagen.com>,
Charlene Liang <cliang_at_curagen.com> wrote:
>We would like to know if we can get information such as number of
>columns in a table from PL/SQL?
One of these will work:
SELECT TABLE_NAME, COUNT(*) COL_TOTAL
FROM USER_TAB_COLUMNS
GROUP BY TABLE_NAME;
or
SELECT COUNT(*) COL_TOTAL
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = 'EMP';
HTH
Steve Cosner
Received on Wed Aug 14 1996 - 00:00:00 CEST