1.添加字段
-- Add/modify columns 
alter table YY_PL_ORDERCOLLECTION add lastzzdate varchar2(10);
alter table YY_PL_ORDERCOLLECTION add lasthcdate varchar2(10);
alter table YY_PL_ORDERCOLLECTION add lastbzdate varchar2(10);
-- Add comments to the columns 
comment on column YY_PL_ORDERCOLLECTION.lastzzdate
  is '最后组装日期';
comment on column YY_PL_ORDERCOLLECTION.lasthcdate
  is '最后化成日期';
comment on column YY_PL_ORDERCOLLECTION.lastbzdate
  is '最后包装日期';


2.select t.*,t.rowid from yy_sys_datapermission t order by t.datapermissioncode;
15	402880f8337d0ae801337d2110060901	10061001	总表_出口配套	com.hb.applet.panels.PlReportPanel	tbckpt	记录号,计划单号,成品电池编码,电池型号,焊接方式,客户,正反装,端子型号,需货期,订单数量,组装数量,库存报废数量,欠组装数量,加酸数量,库存报废数量,欠加酸数量,出槽数量,包装数量,欠包装数量,最后组装日期,最后化成日期,最后包装日期	recordcode,plancode,ncfprocode,invtype,weldingway,customer,pntype,terminaltype,needdate,num,zznum,zzbfnum,unzznum,jsnum,jsbfnum,unjsnum,outnum,bznum,unbznum,lastzzdate,lasthcdate,lastbzdate	10,11,12,13,14,15,16,17,18	-16776961,-16776961,-65536,-16776961,-16776961,-65536,-16776961,-16776961,-65536			2012-03-02 16:25:06	0	0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18	100,80,80,110,50,70,50,50,70,70,70,75,70,75,75,75,75,70,75	AAAU8EAAGAACe1zAAE


3.
-- Create table
create global temporary table YY_PL_TEMP_lastDate
(
  PK VARCHAR2(100),
  lDate varchar2(100)
  
)
on commit preserve rows;