开发者

ORA-00911 error in oracle

                   DELETE FROM R1_;
                        DELETE FROM C1;
                        DELETE FROM R1;     

                        INSERT INTO R1_(ID,PRODUCTID1)
                        SELECT A.SIPARISHEADER_ID,A.PRODUCTID FROM TBLSIPARIS A
                        GROUP BY A.PRODUCTID,A.SIPARISHEADER_ID 
                        ORDER BY PRODUCTID;

                        INSERT INTO C1(PRODUCTID1,SUPP开发者_StackOverflow中文版ORT )
                        SELECT A.PRODUCTID1,COUNT(*)  FROM R1_ A
                        GROUP BY A.PRODUCTID1
                        HAVING COUNT(*)>2;

                        INSERT INTO R1(ID,PRODUCTID1)
                        SELECT A.ID,A.PRODUCTID1 FROM R1_ A, C1 B
                        WHERE A.PRODUCTID1 = B.PRODUCTID1;

                        SELECT A.PRODUCTID1,B.PRODUCTNAME PRODUCTNAME1,A.SUPPORT FROM C1 A
                        JOIN TBLPRODUCTS B ON (A.PRODUCTID1 = B.PRODUCTID);


I would recommend:

  1. Get into SQL*Plus
  2. Copy and paste each statement and execute, one by one.
  3. Report back the statement that exhibits the error
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜