CREATE TABLE AS SELECT

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 Received on Fri Jun 25 1999 - 07:05:35 CDT