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_sequenceminvalue 0maxvalue 999999999999999999start with 0increment by 1cache 20;3、创建触发器cr