Gerador de dados DUMMY para qualquer tabela.<\/p>\n
[crayon]<\/p>\n
CREATE OR REPLACE PROCEDURE popula_anytable(p_tname IN VARCHAR2
\n,p_records IN NUMBER) AUTHID CURRENT_USER AS
\nl_insert LONG;
\nl_rows NUMBER DEFAULT 0;
\nBEGIN
\nl_insert := ‘insert into ‘ || p_tname || ‘ select ‘;<\/p>\n
FOR x IN (SELECT data_type
\n,data_length
\n,rpad(‘9’, data_precision, ‘9’) \/ power(10, data_scale) maxval
\nFROM user_tab_columns
\nWHERE table_name = upper(p_tname)
\nORDER BY column_id)
\nLOOP
\nIF (x.data_type IN (‘NUMBER’, ‘FLOAT’)) THEN
\nl_insert := l_insert || ‘dbms_random.value(1,’ || x.maxval || ‘),’;
\nELSIF (x.data_type = ‘DATE’) THEN
\nl_insert := l_insert ||
\n‘sysdate+dbms_random.value+dbms_random.value(1,1000),’;
\nELSE
\nl_insert := l_insert || ‘dbms_random.string(”A”,’ || x.data_length || ‘),’;
\nEND IF;
\nEND LOOP;
\nl_insert := rtrim(l_insert, ‘,’) ||
\n‘ from all_objects where rownum <= :n’;<\/p>\n
LOOP
\nEXECUTE IMMEDIATE l_insert
\nUSING p_records – l_rows;
\nl_rows := l_rows + SQL%ROWCOUNT;
\nEXIT WHEN(l_rows >= p_records);
\nEND LOOP;
\nEND;<\/p>\n
[\/crayon]<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
Gerador de dados DUMMY para qualquer tabela. [crayon] CREATE OR REPLACE PROCEDURE popula_anytable(p_tname IN VARCHAR2 ,p_records IN NUMBER) AUTHID CURRENT_USER AS l_insert LONG; l_rows NUMBER… <\/p>\n","protected":false},"author":1,"featured_media":10397,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,138],"tags":[],"class_list":["post-9762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-base-de-conhecimentos","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/9762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9762"}],"version-history":[{"count":3,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/9762\/revisions"}],"predecessor-version":[{"id":10469,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/9762\/revisions\/10469"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/media\/10397"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}