Re: Insert count into a db - missing expression

On Wed, 22 Aug 2001 15:04:37 -0700, "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote:

>> 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
>

Thank You!! It worked.

On the alias, I was just trying everything. I did try without the alias and it failed too, so something else was causing the problem. I do not know exactly what was causing the error in my old stmt, but your way is cleaner and it works.

Thx,
Scott Received on Thu Aug 23 2001 - 10:32:03 CDT