Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00903

Re: ORA-00903

From: <fitzjarrell_at_cox.net>
Date: Wed, 01 Aug 2007 10:02:05 -0700
Message-ID: <1185987725.255818.294400@g12g2000prg.googlegroups.com>


On Aug 1, 11:27 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Aug 1, 11:05 am, Sashi <small..._at_gmail.com> wrote:
>
>
>
>
>
> > All, I must be missing the woods 'coz of the trees but here goes:
> > =============================================================
> > SQL> desc NED_PRODUCT_CARD;
> > Name Null? Type
> > ----------------------------------------- --------
> > ----------------------------
> > PRODUCT_CARD_KEY NOT NULL NUMBER(10)
> > DATA_SOURCE_NAME VARCHAR2(120)
> > PL_CGIS VARCHAR2(100)
> > REMS_CODE NOT NULL VARCHAR2(10)
> > BUILDING_CODE VARCHAR2(10)
> > FLOOR VARCHAR2(100)
> > SECTOR VARCHAR2(100)
> > SITE_ID VARCHAR2(20)
> > TOTAL_RSF NUMBER
> > RECORD_CREATED_DATE DATE
> > RECORD_UPDATED_DATE DATE
>
> > SQL> delete * from NED_PRODUCT_CARD
> > 2 where PL_CGIS in (
> > 3 "UUS607CRS",
> > "UUSBLANKUND",
> > "UUSBLANKVAC-CO",
> > "UUSBLANKVAC-EX",
> > "UUSPriamerica",
> > "USSBCRS");
> > 4 5 6 7 8 delete * from NED_PRODUCT_CARD
> > *
> > ERROR at line 1:
> > ORA-00903: invalid table name
> > =============================================================
> > As can be seen, I have the NED_PRODUCT_CARD table defined and all.
> > When I try to delete certain rows, the error says that the table
> > doesn't exist.
>
> > What gives??!!
>
> > Thanks,
> > Sashi
>
> It is a syntax problem with the DELETE statement. An example:
> CREATE TABLE T1 (C1 VARCHAR2(10));
>
> Table created.
>
> INSERT INTO T1 VALUES ('AAAA');
> INSERT INTO T1 VALUES ('AAAB');
> INSERT INTO T1 VALUES ('AAAC');
> INSERT INTO T1 VALUES ('AAAD');
>
> Now a test:
> DELETE * FROM T1;
>
> ERROR at line 1:
> ORA-00903: invalid table name
>
> Now, the correct syntax:
> DELETE FROM T1;
>
> 4 rows deleted.
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.- Hide quoted text -
>
> - Show quoted text -

And your next problem is the "" around your string values; those should be single quotes:

delete from NED_PRODUCT_CARD
where PL_CGIS in (

'UUS607CRS',
'UUSBLANKUND',
'UUSBLANKVAC-CO',
'UUSBLANKVAC-EX',
'UUSPriamerica',
'USSBCRS');


David Fitzjarrell Received on Wed Aug 01 2007 - 12:02:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US