<\/p>\n
select substr(a.OWNER,1,20)<\/p>\n
, substr(a.NAME,1,30)<\/p>\n
, substr(a.TYPE,1,20)\u00a0<\/p>\n
, substr(u.status,1,10) Stat<\/p>\n
, u.last_ddl_time<\/p>\n
, substr(text,1,80) Description\u00a0<\/p>\n
from dba_source a, dba_objects u\u00a0<\/p>\n
WHERE 2=2\u00a0<\/p>\n
and u.object_name = a.name\u00a0<\/p>\n
and a.text like ‘%Header%’\u00a0<\/p>\n
and a.type = u.object_type\u00a0<\/p>\n
and a.name like ‘PA_%API%’ \u00a0— Trocar PA pelo sigla do m\u00f3dulo desejado. Exemplo: AP, GL, PO, INV<\/p>\n
order by\u00a0<\/p>\n
a.owner, a.name;<\/p>\n
<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
select substr(a.OWNER,1,20) , substr(a.NAME,1,30) , substr(a.TYPE,1,20)\u00a0 , substr(u.status,1,10) Stat , u.last_ddl_time , substr(text,1,80) Description\u00a0 from dba_source a, dba_objects u\u00a0 WHERE 2=2\u00a0 and u.object_name = a.name\u00a0… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,127,124,126,110],"tags":[],"class_list":["post-9009","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-applications","category-database","category-developer-tools","category-estudo-e-pesquisa"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/9009","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=9009"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/9009\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}