u010790770的专栏

select COLUMN_NAME from sysibm.columns where table_schema='ADMINISTRATOR' " + "AND TABLE_NAME='T_BAS_ENTERPRISE' ORDER BY ORDINAL_POSITION";

CREATE OR REPLACE  procedure pro_getBaseNo_BASEINFORMATION(str in varchar2,p_baseno out varchar2)   is     v_count number;         begin     select str||lpad(trunc(dbms_random.value(1,1000)),6,'0

1、创建表 create table emp( id number, name varchar2(30) ); 2、创建序列 create sequence emp_sequence minvalue 0 maxvalue 999999999999999999 start with 0 increment by 1 cache 20; 3、创建触发器 cr