{"id":1025,"date":"2013-07-03T17:53:08","date_gmt":"2013-07-03T15:53:08","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1025"},"modified":"2013-07-03T17:53:08","modified_gmt":"2013-07-03T15:53:08","slug":"sql-szybkie-listowanie-kolumn-tabeli-w-sql","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1025","title":{"rendered":"SQL &#8211; szybkie listowanie kolumn tabeli w sql"},"content":{"rendered":"<p>przydatne do insert\u00f3w<\/p>\n<pre>select ':new.'||COLUMN_NAME||',' from \r\n ALL_TAB_COLUMNS cols \r\nwhere \r\n cols.TABLE_NAME = 'RA_INTERFACE_LINES_ALL'\r\norder by cols.column_name;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>przydatne do insert\u00f3w select &#8217;:new.&#8217;||COLUMN_NAME||&#8217;,&#8217; from ALL_TAB_COLUMNS cols where cols.TABLE_NAME = 'RA_INTERFACE_LINES_ALL&#8217; order by cols.column_name;<\/p>\n","protected":false},"author":38,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[186],"tags":[193,192,73],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1025"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1025"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1025\/revisions"}],"predecessor-version":[{"id":1027,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1025\/revisions\/1027"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}