Re: CREATE TABLE AS SELECT

From: Ed Prochak <prochak_at_my-deja.com>
Date: Fri, 25 Jun 1999 17:04:43 GMT
Message-ID: <7l0cr2$9g7$1@nnrp1.deja.com>

Tried ALTER TABLE ???

In article <37736fb2.1063919_at_news.earthlink.net>, Jeremy.Russell_at_I-got-all-the-spam-i-need.usa.net (Jeremy Russell) wrote:
> Running the following SQL statement creates a summary table from
> SCOTT's employee table. Using 'depttot' as an alias allows me to name
> the aggregate column - but how can I assign a specific scale and
> precision to that column?
>
> CREATE TABLE emp_summary AS
> SELECT deptno, sum(sal) depttot
> FROM emp
> GROUP BY deptno
>
> Thanks ...
>
> Jeremy Russell
>
>

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 12:04:43 CDT