Table_Random 컬럼 생성
--랜덤 생성 쿼리 좋다, procedure로 10000개 생성해보자. INSERT into meta_tables(OWNER ,TABLE_NAME , TABLESPACE_NAME) values ('TEST_AAA'||RPAD(CEIL(DBMS_RANDOM.VALUE*1000),4,'ABC') ,'TEST_BBB'||RPAD(CEIL(DBMS_RANDOM.VALUE*1000),4,'ABC') ,'TEST_CCC'||RPAD(CEIL(DBMS_RANDOM.VALUE*1000),4,'ABC')); BEGIN FOR i IN 1 .. 5000 LOOP INSERT INTO meta_tables(OWNER, TABLE_NAME, TABLESPACE_NAME, CLUSTER_NAME, IOT_NAME, STATUS..
더보기