{"id":65,"date":"2009-06-22T12:58:52","date_gmt":"2009-06-22T19:58:52","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=65"},"modified":"2009-11-26T05:41:29","modified_gmt":"2009-11-26T12:41:29","slug":"jdbc-getmetadata-ampliado","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2009\/06\/22\/jdbc-getmetadata-ampliado\/","title":{"rendered":"Jdbc getMetaData ampliado"},"content":{"rendered":"<p>El driver de Oracle nos entrega lo que la espcificaci\u00f3n obliga, pero internamente los comentarios los configura en null, para poder simular una consulta de forma de poder extraer los comentarios entonces se puede utilizar<\/p>\n<pre class=\"brush: sql\">SELECT NULL AS table_cat,\r\no.owner AS table_schem,\r\no.object_name AS table_name,\r\no.object_type AS table_type,\r\nC.COMMENTS AS remarks\r\nFROM all_objects o,ALL_TAB_COMMENTS C\r\nWHERE o.owner LIKE 'tu_esquema' ESCAPE '\/'\r\nAND o.object_type IN ('xxx', 'TABLE', 'VIEW')\r\nAND o.owner= c.owner\r\nAND o.object_name= c.table_name\r\nORDER BY table_type, table_schem, table_name<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>El driver de Oracle nos entrega lo que la espcificaci\u00f3n obliga, pero internamente los comentarios los configura en null, para poder simular una consulta de forma de poder extraer los comentarios entonces se puede utilizar SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, C.COMMENTS AS remarks FROM all_objects o,ALL_TAB_COMMENTS C [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4,6,9],"tags":[],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-desarrollo","category-java","category-oracle"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/65"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=65"}],"version-history":[{"count":4,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/65\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}