{"id":368,"date":"2016-07-14T13:25:35","date_gmt":"2016-07-14T13:25:35","guid":{"rendered":"https:\/\/blogs.ua.es\/jpm33\/?p=368"},"modified":"2016-07-14T13:25:35","modified_gmt":"2016-07-14T13:25:35","slug":"obtener-vistas-relacionadas-en-oracle","status":"publish","type":"post","link":"https:\/\/blogs.ua.es\/jpm33\/2016\/07\/14\/obtener-vistas-relacionadas-en-oracle\/","title":{"rendered":"Obtener vistas relacionadas en Oracle"},"content":{"rendered":"<h1>Introducci\u00f3n<\/h1>\n<p>En ocasiones estamos manejado vistas o elementos de PL\/SQL que necesitamos saber que relaci\u00f3n existe entre ellos. Para esto oracle nos ofrece la vista <strong>user_dependencies<\/strong> que relaciona un objeto (vista, package, function, procedure) con otro si \u00e9ste es dependencia de otro.<\/p>\n<h1>Caso de pruebas<\/h1>\n<p>Supongamos una vista <strong>ALUMNOS<\/strong> que se usa para hacer consulta, se consume en 1 procedure y 1 function. Si ejecutamos una consulta como la siguiente:<\/p>\n<pre><code>\r\nSELECT * FROM user_dependencies\r\n  START WITH name = 'ALUMNOS'\r\n  CONNECT BY PRIOR TRIM(referenced_name) = TRIM(name);\r\n<\/code>\r\n<\/pre>\n<p>Obtendremos un resultado como el siguiente, donde veremos en la columna de la izquierda para cada ocurrencia de la izquierda en que elemento de la derecha esta como una dependencia.<a href=\"https:\/\/blogs.ua.es\/jpm33\/files\/2016\/07\/Vistas_relacionadas_Oracle.png\" target=\"_blank\"><br \/>\n<img decoding=\"async\" src=\"https:\/\/blogs.ua.es\/jpm33\/files\/2016\/07\/Vistas_relacionadas_Oracle.png\" \/><br \/>\n<\/a><\/p>\n<h1>Referencias<\/h1>\n<ol>\n<li><strong>USER_DEPENDENCIES<\/strong>:<br \/>\n<a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/statviews_5252.htm\" target=\"_blank\">https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/statviews_5252.htm<\/a><\/li>\n<li><strong>ALL_DEPENDENCIES<\/strong>:<br \/>\n<a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/statviews_1066.htm#i1576452\" target=\"_blank\">https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28320\/statviews_1066.htm#i1576452<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Introducci\u00f3n En ocasiones estamos manejado vistas o elementos de PL\/SQL que necesitamos saber que relaci\u00f3n existe entre ellos. Para esto oracle nos ofrece la vista user_dependencies que relaciona un objeto (vista, package, function, procedure) con otro si \u00e9ste es dependencia &hellip; <a href=\"https:\/\/blogs.ua.es\/jpm33\/2016\/07\/14\/obtener-vistas-relacionadas-en-oracle\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3080,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[374,236732,236731],"tags":[236718,1839,23],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-programacion","category-sql","category-web","tag-programacion-2","tag-sql","tag-web"],"_links":{"self":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/users\/3080"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":4,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/368\/revisions\/372"}],"wp:attachment":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}