Insert count into a db - missing expression

From: Scott <scott_at_yahoo.com>
Date: Wed, 22 Aug 2001 20:11:11 GMT
Message-ID: <3b840efb.22950210@news.onvoy.com>

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> Received on Wed Aug 22 2001 - 15:11:11 CDT