{"id":513,"date":"2011-10-26T13:21:29","date_gmt":"2011-10-26T11:21:29","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=513"},"modified":"2011-11-18T12:27:34","modified_gmt":"2011-11-18T10:27:34","slug":"dane-z-pliku-tekstowego-jako-tabela-w-oracle","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=513","title":{"rendered":"dane z pliku tekstowego jako tabela w oracle"},"content":{"rendered":"<p>W oracle mo\u017cna czyta\u0107 dane z pliku tekstowego jak ze zwyk\u0142ej tabeli. Setup;<\/p>\n<p>1) Utworzy\u0107 folder na serwerze bazy danych. Nada\u0107 prawa do zapisu w folderze.<\/p>\n<p>2) Zdefiniowa\u0107 folder w oracle\u00a0<!--more--><\/p>\n<pre>create directory USG_ODM_ITEMS_01 as '\/dbtmp\/QMGLOB\/USG_ODM_ITEMS';<\/pre>\n<p>3) Zdefniowa\u0107 tabel\u0119<\/p>\n<pre>CREATE TABLE XX_USG_ODM_ITEMS2LOAD (\r\n\r\nload varchar2(100),\r\nitem varchar2(100),\r\nUM varchar2(100),\r\ndescription varchar2(250),\r\ncost_std varchar2(250),\r\nerror_message varchar2(250)\r\n\r\n)\r\nORGANIZATION EXTERNAL\r\n ( type oracle_loader\r\n    default directory USG_ODM_ITEMS_01\r\n   access parameters\r\n    (\r\n      records delimited BY newline\r\n      skip 1\r\n      fields terminated by ';'\r\n      missing field values are null\r\n    )\r\n   location ('usg_odm_items_2_load.csv')\r\n )<\/pre>\n<p>&nbsp;<\/p>\n<p>Wgra\u0107 plik i wykona\u0107 zapytanie:<\/p>\n<pre>select * from XX_USG_ODM_ITEMS2LOAD t1<\/pre>\n<div id='gallery-1' class='gallery galleryid-513 gallery-columns-3 gallery-size-thumbnail'><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/dane-zpliku-1.png'><img width=\"150\" height=\"150\" src=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/dane-zpliku-1-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/dane-zpliku-1-150x150.png 150w, https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/dane-zpliku-1-90x90.png 90w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/folder-z-prawami-zapisu.png'><img width=\"150\" height=\"150\" src=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/folder-z-prawami-zapisu-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/folder-z-prawami-zapisu-150x150.png 150w, https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/folder-z-prawami-zapisu-90x90.png 90w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/zapytanie.png'><img width=\"150\" height=\"150\" src=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/zapytanie-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/zapytanie-150x150.png 150w, https:\/\/oracle.malin.pl\/wp-content\/uploads\/2011\/10\/zapytanie-90x90.png 90w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><br style=\"clear: both\" \/>\n\t\t<\/div>\n\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>W oracle mo\u017cna czyta\u0107 dane z pliku tekstowego jak ze zwyk\u0142ej tabeli. Setup; 1) Utworzy\u0107 folder na serwerze bazy danych. Nada\u0107 prawa do zapisu w folderze. 2) Zdefiniowa\u0107 folder w oracle\u00a0<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[88],"tags":[89,91,90],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/513"}],"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\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=513"}],"version-history":[{"count":5,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":518,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions\/518"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}