我在oracle查询中使用XMLSerializer来执行linux作业。在SQLDeveloper命令选项卡上,一切看起来都很好,但在linux上,我看到xml输出被空格所跟踪:--WHENEVERSET HEAD OFFset linesize 180set long 100000SPOOLparent&quo
我编写了一个存储过程如下:product prod.product_number%TYPE;
DBMS_OUTPUT.enable();
insert into product select unique product_number from prod p where mynumber not in('R44','R76','R79','R20','R0