在PLSQL中可以执行的语句在DELPHI中不能执行?
-- Create table
create global temporary table TTMPSALPACKPLU_TMPlsl
(
ORGCODE VARCHAR2(10),
SALENO VARCHAR2(20),
XSDATE DATE,
PAGENO NUMBER(10),
LNNO NUMBER(10),
PLUID NUMBER(19),
PLUCODE VARCHAR2(20),
PLUNAME VARCHAR2(40),
EXPLUCODE VARCHAR2(20),
BARCODE VARCHAR2(20),
UNIT VARCHAR2(6),
SPEC VARCHAR2(40),
PRICE NUMBER(19,4),
FSPRICE NUMBER(19,4),
XSCOUNT NUMBER(19,4),
YSTOTAL NUMBER(19,2),
SSTOTAL NUMBER(19,2),
YHTOTAL NUMBER(19,2),
XFTYPE VARCHAR2(1),
VIPCARDNO VARCHAR2(40),
CXBILLNO VARCHAR2(20),
HYBILLNO VARCHAR2(20)
)
On Commit Delete Rows;
-- Create table
create global temporary table TTMPSALPACKMXPLU_TMPlsl
(
ORGCODE VARCHAR2(10),
SALENO VARCHAR2(20),
XSDATE DATE,
PAGENO NUMBER(10),
LNNO NUMBER(10),
PACKCODE VARCHAR2(20),
PLUID NUMBER(19),
PLUCODE VARCHAR2(20),
PLUNAME VARCHAR2(40),
EXPLUCODE VARCHAR2(20),
BARCODE VARCHAR2(20),
UNIT VARCHAR2(6),
SPEC VARCHAR2(40),
DEPID NUMBER(19),
DEPCODE VARCHAR2(10),
DEPNAME VARCHAR2(100),
PRICE NUMBER(19,4),
FSPRICE NUMBER(19,4),
XSCOUNT NUMBER(19,4),
SSTOTAL NUMBER(19,2),
XFTYPE VARCHAR2(1),
VIPCARDNO VARCHAR2(40),
CXBILLNO VARCHAR2(20),
HYBILLNO VARCHAR2(20)
)
on commit Delete rows;
-----整理商品包
Insert into TTMPSALPACKPLU_TMPlsl nologging (OrgCode,SaleNo,XsDate,PageNo,LnNo,PluID,PluCode,PluName,ExPluCode,
BarCode,Unit,Spec,