Re: Insert count into a db - missing expression

> I would like to insert a record count of 1 db into another db. Below
> is what I have tried so far. They all received the missing expression
> error.
>
> What do you think I am missing?
>
> Thx,
> Scott
>
> Connected to:
> Oracle7 Workgroup Server Release 7.3.4.0.0 - Production
> With the distributed option
> PL/SQL Release 2.3.4.0.0 - Production
>
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,1)
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,1)
>
> 1 row created.
>
> SQL>
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2 Values (sysdate,(Select Count(*) as TotalCount
> 3* From EOMatStg24HrsGroupedAr1))
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2 Values (sysdate,(Select Count(*) as TotalCount
> 3* From EOMatStg24HrsGroupedAr1))
> Values (sysdate,(Select Count(*) as TotalCount
> *
> ERROR at line 2:
> ORA-00936: missing expression
>
> SQL>
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) as TotalCount From
> EOMatStg24HrsGrouped
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) as TotalCount From
> EOMatStg24HrsGrouped
> Values (sysdate,(Select Count(*) as TotalCount From
> EOMatStg24HrsGroupedAr1))
> *
> ERROR at line 2:
> ORA-00936: missing expression
>
> SQL>
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) From EOMatStg24HrsGroupedAr1))
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) From EOMatStg24HrsGroupedAr1))
> Values (sysdate,(Select Count(*) From EOMatStg24HrsGroupedAr1))
> *
> ERROR at line 2:
> ORA-00936: missing expression
>
> SQL>
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) "TotalCount" From
> EOMatStg24HrsGroupedA
> SQL>
> 1 Insert Into EOMatStgMan1 (RecDate,TotRec)
> 2* Values (sysdate,(Select Count(*) "TotalCount" From
> EOMatStg24HrsGroupedA
> Values (sysdate,(Select Count(*) "TotalCount" From
> EOMatStg24HrsGroupedAr1))
> *
> ERROR at line 2:
> ORA-00936: missing expression
>
> SQL>
INSERT INTO EOMatStgMan1
(RecDate,TotRec)
SELECT SYSDATE, COUNT(*)
FROM EOMatStg24HrsGroupedAr1;

may work a bit better.

BTW: Why alias a field that is not being displayed?

Daniel A. Morgan Received on Wed Aug 22 2001 - 17:04:37 CDT