{"id":1148,"date":"2014-07-14T10:04:34","date_gmt":"2014-07-14T07:04:34","guid":{"rendered":"http:\/\/zoharelkayam.wordpress.com\/?p=1148"},"modified":"2017-03-16T23:21:53","modified_gmt":"2017-03-16T21:21:53","slug":"sqlunloader-guide","status":"publish","type":"post","link":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/","title":{"rendered":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader"},"content":{"rendered":"

\u05e4\u05e2\u05dd \u05e4\u05e2\u05dd, \u05de\u05d6\u05de\u05df \u05de\u05d6\u05de\u05df, \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e4\u05d9\u05e6'\u05e8\u05d9\u05dd \u05e9\u05dc SQL*Plus<\/a> \u05d5\u05d0\u05d7\u05e8\u05d9 \u05d6\u05d4 \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05d5\u05d3 \u05e4\u05d5\u05e1\u05d8 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e7\u05d5\u05d3 PL\/SQL<\/a>.<\/p>\n

\u05d4\u05d9\u05d5\u05dd \u05e0\u05d3\u05d1\u05e8 \u05e2\u05dc \u05db\u05dc\u05d9 \u05d7\u05d9\u05e6\u05d5\u05e0\u05d9 (\u05d7\u05d9\u05e0\u05de\u05d9 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05dc\u05d0 \u05de\u05e1\u05d7\u05e8\u05d9) \u05e9\u05de\u05d0\u05e4\u05e9\u05e8 \u05dc\u05e0\u05d5 \u05dc\u05ea\u05ea \u05dc\u05d5 \u05de\u05e6\u05d3 \u05d0\u05d7\u05d3 \u05e9\u05dc\u05d9\u05e4\u05d4 (\u05d0\u05d5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8 \u05e2\u05dd \u05e9\u05dc\u05d9\u05e4\u05d4) \u05d5\u05de\u05e6\u05d3 \u05e9\u05e0\u05d9 \u05dc\u05e7\u05d1\u05dc \u05e7\u05d5\u05d1\u05e5 CSV \u05ea\u05e7\u05d9\u05df \u05dc\u05de\u05d4\u05d3\u05e8\u05d9\u05df. \u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d4\u05de\u05d2\u05e0\u05d9\u05d1\u05d4 \u05d4\u05d6\u05d5 \u05e0\u05e7\u05e8\u05d0\u05ea SQL*Unloader.<\/p>\n

\u05d4\u05db\u05dc\u05d9 \u05e4\u05d5\u05ea\u05d7 \u05e2\u05dc \u05d9\u05d3\u05d9 FangXin Lou \u05e9\u05d4\u05d5\u05d0 Oracle Ace<\/a> \u05de\u05e1\u05d9\u05df.<\/p>\n

<\/p>\n

\u05de\u05d4 \u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05de\u05d0\u05e4\u05e9\u05e8\u05ea \u05dc\u05e0\u05d5 \u05dc\u05e2\u05e9\u05d5\u05ea<\/h2>\n

\u05de\u05d3\u05d5\u05d1\u05e8 \u05d1\u05ea\u05d5\u05db\u05e0\u05d4 \u05de\u05d0\u05d5\u05d3 \u05e4\u05e9\u05d5\u05d8\u05d4 \u05e9\u05d9\u05d5\u05d3\u05e2\u05ea \u05dc\u05e7\u05d1\u05dc \u05e1\u05d8 \u05de\u05d0\u05d5\u05d3 \u05de\u05d5\u05d2\u05d3\u05e8 \u05e9\u05dc \u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05d5\u05de\u05d5\u05e6\u05d9\u05d0\u05d4 \u05dc\u05e0\u05d5 \u05de\u05d4\u05e6\u05d3 \u05d4\u05e9\u05e0\u05d9 \u05e7\u05d5\u05d1\u05e5 CSV.<\/p>\n

\u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d4\u05e4\u05e9\u05d5\u05d8\u05d4 \u05d4\u05d6\u05d5 \u05de\u05d2\u05d9\u05e2\u05d4 \u05d1\u05d0\u05e8\u05d1\u05e2 \u05d2\u05e8\u05e1\u05d0\u05d5\u05ea: Windows, Windows 64, Linux, Linux64 \u05d5\u05d4\u05d9\u05d0 \u05db\u05ea\u05d5\u05d1\u05d4 \u05d1\u05e9\u05e4\u05ea C \u05d5\u05d1\u05e9\u05d9\u05de\u05d5\u05e9 \u05e9\u05dc OCI8 (\u05db\u05dc\u05d5\u05de\u05e8, \u05d4\u05d9\u05d0 \u05ea\u05d5\u05de\u05db\u05ea \u05de\u05d2\u05e8\u05e1\u05d4 9 \u05e2\u05d3 11 \u05db\u05d5\u05dc\u05dc, \u05e2\u05d5\u05d3 \u05dc\u05d0 \u05d1\u05d3\u05e7\u05ea\u05d9 \u05e2\u05dc 12).<\/p>\n

\u05d0\u05ea \u05d4\u05e7\u05d5\u05d3 \u05d4\u05de\u05e7\u05d5\u05de\u05e4\u05dc (\u05d1\u05d9\u05e0\u05d0\u05e8\u05d9\u05dd) \u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05d5\u05e8\u05d9\u05d3 \u05db\u05d0\u05df: http:\/\/www.anysql.net\/software\/ociuldr.zip \u05d0\u05d5 \u05de\u05e4\u05d4 http:\/\/www.anysql.net\/software\/sqluldr.zip<\/a><\/p>\n

\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05de\u05e9\u05ea\u05de\u05e9 (\u05dc\u05d0 \u05d1\u05d8\u05d5\u05d7 \u05e9\u05de\u05e2\u05d5\u05d3\u05db\u05df): www.dbatools.net\/doc\/ociuldr<\/strong>.pdf<\/p>\n

\u05e2\u05d3\u05db\u05d5\u05df (09.12.2015): \u05d0\u05ea \u05e7\u05d5\u05d3 \u05d4\u05de\u05e7\u05d5\u05e8 \u05e9\u05dc \u05d4\u05d2\u05e8\u05e1\u05d4 \u05d4\u05e7\u05d5\u05d3\u05de\u05ea \u05e9\u05dc \u05d4\u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d4\u05d9\u05d4 \u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05d5\u05e8\u05d9\u05d3 \u05de-github \u05d0\u05d1\u05dc \u05db\u05d1\u05e8 \u05dc\u05d0…<\/p>\n

\u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05e9\u05e7\u05d5\u05d3 \u05d4\u05de\u05e7\u05d5\u05e8 \u05d4\u05d5\u05d0 \u05dc\u05d0 \u05e9\u05dc \u05d4\u05d2\u05e8\u05e1\u05d4 \u05d4\u05d0\u05d7\u05e8\u05d5\u05e0\u05d4 (\u05dc\u05d3\u05d5\u05d2\u05de\u05d4, \u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 help \u05dc\u05d0 \u05e7\u05d9\u05d9\u05de\u05ea \u05e9\u05dd). \u05d4\u05e7\u05d1\u05e6\u05d9\u05dd \u05d4\u05de\u05e7\u05d5\u05de\u05e4\u05dc\u05d9\u05dd \u05d4\u05dd \u05d4\u05d2\u05e8\u05e1\u05d4 \u05d4\u05d0\u05d7\u05e8\u05d5\u05e0\u05d4 \u05e9\u05d0\u05e0\u05d9 \u05d4\u05e6\u05dc\u05d7\u05ea\u05d9 \u05dc\u05de\u05e6\u05d5\u05d0.<\/p>\n

\u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd<\/h2>\n

\u05d1\u05d5\u05d0\u05d5 \u05e0\u05e2\u05d1\u05d5\u05e8 \u05e2\u05dc \u05db\u05de\u05d4 \u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05d7\u05e9\u05d5\u05d1\u05d9\u05dd \u05e9\u05db\u05d3\u05d0\u05d9 \u05dc\u05d4\u05db\u05d9\u05e8:<\/p>\n

    \n
  • \u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05e8\u05d9\u05e5 \u05e9\u05dc\u05d9\u05e4\u05d5\u05ea \u05d1-clear text (query) \u05d0\u05d5 \u05db\u05e7\u05d5\u05d1\u05e5 (sql). \u05d1\u05e7\u05d5\u05d1\u05e5 \u05d4-SQL \u05d0\u05d9\u05df \u05e6\u05d5\u05e8\u05da \u05d1\u05e9\u05d5\u05dd \u05d3\u05d1\u05e8 \u05d7\u05d5\u05e5 \u05de\u05d4\u05e4\u05e7\u05d5\u05d3\u05d4 \u05e2\u05e6\u05de\u05d4. \u05d0\u05dd \u05d4\u05e7\u05d5\u05d1\u05e5 \u05de\u05e7\u05d1\u05dc \u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1\u05e4\u05e8\u05de\u05d8\u05e8 exec \u05db\u05d3\u05d9 \u05dc\u05d8\u05e4\u05dc \u05d1\u05d6\u05d4.<\/li>\n
  • \u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d9\u05d5\u05d3\u05e2\u05ea \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1-delimiter \u05de\u05d5\u05d2\u05d3\u05e8 \u05dc\u05e2\u05de\u05d5\u05d3\u05d5\u05ea (record) \u05d0\u05d5 \u05dc\u05e9\u05d5\u05e8\u05d5\u05ea (rows).<\/li>\n
  • \u05d1\u05e8\u05d9\u05e8\u05ea \u05d4\u05de\u05d7\u05d3\u05dc \u05e9\u05dc \u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d4\u05d9\u05d0 \u05dc\u05d0 \u05dc\u05d4\u05e6\u05d9\u05d2 \u05d0\u05ea \u05d4\u05db\u05d5\u05ea\u05e8\u05ea \u05e9\u05dc \u05d4\u05e9\u05dc\u05d9\u05e4\u05d4. \u05d4\u05e4\u05e8\u05de\u05d8\u05e8 head \u05de\u05e9\u05e0\u05d4 \u05d0\u05ea \u05d4\u05d4\u05d2\u05d3\u05e8\u05d4 \u05d4\u05d6\u05d5 (head=yes).<\/li>\n
  • \u05d4\u05ea\u05d5\u05db\u05e0\u05d4 \u05d9\u05d5\u05d3\u05e2\u05ea \u05dc\u05d4\u05d5\u05e6\u05d9\u05d0 \u05d0\u05ea \u05d4\u05e7\u05d1\u05e6\u05d9\u05dd \u05d1\u05e4\u05d5\u05e8\u05de\u05d8\u05d9\u05dd \u05e9\u05d5\u05e0\u05d9\u05dd (\u05dc\u05d0 \u05e8\u05e7 CSV): \u05d4\u05e4\u05e8\u05de\u05d8\u05e8 text \u05e9\u05d5\u05dc\u05d8 \u05d1\u05d6\u05d4.<\/li>\n
  • \u05d4\u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd Presql \u05d5-postsql \u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05e2\u05d6\u05d5\u05e8 \u05d1\u05d4\u05e8\u05e6\u05ea \u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05dc\u05e4\u05e0\u05d9 \u05d5\u05d0\u05d7\u05e8\u05d9 \u05d4\u05e9\u05dc\u05d9\u05e4\u05d4<\/li>\n<\/ul>\n
    \r\n\u00a0\r\n[oracle@dbserver1 zohar]$ .\/sqluldr2_linux64_10204.bin help=yes\r\n\u00a0\r\nSQL*UnLoader: Fast Oracle Text Unloader (GZIP, Parallel), Release 4.0.1\r\n(@) Copyright Lou Fangxin (AnySQL.net) 2004 - 2010, all rights reserved.\r\n\u00a0\r\nLicense: Free for non-commercial useage, else 100 USD per server.\r\n\u00a0\r\nUsage: SQLULDR2 keyword=value [,keyword=value,...]\r\n\r\nValid Keywords:\r\n\u00a0\u00a0 user\u00a0\u00a0\u00a0 = username\/password@tnsname\r\n\u00a0\u00a0 sql\u00a0\u00a0\u00a0\u00a0 = SQL file name\r\n\u00a0\u00a0 query\u00a0\u00a0 = select statement\r\n\u00a0\u00a0 field\u00a0\u00a0 = separator string between fields\r\n\u00a0\u00a0 record\u00a0 = separator string between records\r\n\u00a0\u00a0 rows\u00a0\u00a0\u00a0 = print progress for every given rows (default, 1000000)\r\n\u00a0\u00a0 file\u00a0\u00a0\u00a0 = output file name(default: uldrdata.txt)\r\n\u00a0\u00a0 log\u00a0\u00a0\u00a0\u00a0 = log file name, prefix with + to append mode\r\n\u00a0\u00a0 fast\u00a0\u00a0\u00a0 = auto tuning the session level parameters(YES)\r\n\u00a0\u00a0 text\u00a0\u00a0\u00a0 = output type (MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).\r\n\u00a0\u00a0 charset = character set name of the target database.\r\n\u00a0\u00a0 ncharset= national character set name of the target database.\r\n\u00a0\u00a0 parfile = read command option from parameter file\r\n\u00a0\u00a0 read\u00a0\u00a0\u00a0 = set DB_FILE_MULTIBLOCK_READ_COUNT at session level\r\n\u00a0\u00a0 sort\u00a0\u00a0\u00a0 = set SORT_AREA_SIZE at session level (UNIT:MB)\r\n\u00a0\u00a0 hash\u00a0\u00a0\u00a0 = set HASH_AREA_SIZE at session level (UNIT:MB)\r\n\u00a0\u00a0 array\u00a0\u00a0 = array fetch size\r\n\u00a0\u00a0 head\u00a0\u00a0\u00a0 = print row header(Yes|No)\r\n \u00a0 batch\u00a0\u00a0 = save to new file for every rows batch (Yes\/No)\r\n\u00a0\u00a0 size\u00a0\u00a0\u00a0 = maximum output file piece size (UNIB:MB)\r\n\u00a0\u00a0 serial\u00a0 = set _serial_direct_read to TRUE at session level\r\n\u00a0\u00a0 trace\u00a0\u00a0 = set event 10046 to given level at session level\r\n\u00a0\u00a0 table\u00a0\u00a0 = table name in the sqlldr control file\r\n\u00a0\u00a0 control = sqlldr control file and path.\r\n\u00a0\u00a0 mode\u00a0\u00a0\u00a0 = sqlldr option, INSERT or APPEND or REPLACE or TRUNCATE\r\n\u00a0\u00a0 buffer\u00a0 = sqlldr READSIZE and BINDSIZE, default 16 (MB)\r\n\u00a0\u00a0 long\u00a0\u00a0\u00a0 = maximum long field size\r\n\u00a0\u00a0 width\u00a0\u00a0 = customized max column width (w1:w2:...)\r\n\u00a0\u00a0 quote\u00a0\u00a0 = optional quote string\r\n\u00a0\u00a0 data\u00a0\u00a0\u00a0 = disable real data unload (NO, OFF)\r\n\u00a0\u00a0 alter\u00a0\u00a0 = alter session SQLs to be execute before unload\r\n\u00a0\u00a0 safe\u00a0\u00a0\u00a0 = use large buffer to avoid ORA-24345 error (Yes|No)\r\n\u00a0\u00a0 crypt\u00a0\u00a0 = encrypted user information only (Yes|No)\r\n\u00a0\u00a0 sedf\/t\u00a0 = enable character translation function\r\n\u00a0\u00a0 null\u00a0\u00a0\u00a0 = replace null with given value\r\n\u00a0\u00a0 escape\u00a0 = escape character for special characters\r\n\u00a0\u00a0 escf\/t\u00a0 = escape from\/to characters list\r\n\u00a0\u00a0 format\u00a0 = MYSQL: MySQL Insert SQLs, SQL: Insert SQLs.\r\n\u00a0\u00a0 exec\u00a0\u00a0\u00a0 = the command to execute the SQLs.\r\n\u00a0\u00a0 prehead = column name prefix for head line.\r\n\u00a0\u00a0 rowpre\u00a0 = row prefix string for each line.\r\n\u00a0\u00a0 rowsuf\u00a0 = row sufix string for each line.\r\n\u00a0\u00a0 colsep\u00a0 = separator string between column name and value.\r\n\u00a0\u00a0 presql\u00a0 = SQL or scripts to be executed before data unload.\r\n\u00a0\u00a0 postsql = SQL or scripts to be executed after data unload.\r\n\u00a0\u00a0 lob\u00a0\u00a0\u00a0\u00a0 = extract lob values to single file (FILE).\r\n\u00a0\u00a0 lobdir\u00a0 = subdirectory count to store lob files .\r\n\u00a0\u00a0 split\u00a0\u00a0 = table name for automatically parallelization.\r\n\u00a0\u00a0 degree\u00a0 = parallelize data copy degree (2-128).\r\n\u00a0\u00a0 hint\u00a0\u00a0\u00a0 = MySQL SQL hint for the Insert, for example IGNORE.\r\n\u00a0\u00a0 unique\u00a0 = Unique Column List for the MySQL target table.\r\n\u00a0\u00a0 update\u00a0 = Enable MySQL ON DUPLICATE SQL statement(YES\/NO).\r\n\u00a0\u00a0 crack\u00a0\u00a0 = The crack key for the content protection.\r\n\u00a0\u00a0 uncrack = The uncrack key for the content protection.\r\n\u00a0\r\n\u00a0 for field and record, you can use '0x' to specify hex character code,\r\n\u00a0 r=0x0d n=0x0a |=0x7c ,=0x2c, t=0x09, :=0x3a, #=0x23, &amp;amp;amp;amp;amp;amp;amp;quot;=0x22 '=0x27\r\n<\/pre>\n
    \u05d3\u05d5\u05d2\u05de\u05d4 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9<\/p>\n
    \r\n.\/sqluldr2_linux64_10204.bin user=system\/manager query=&amp;amp;amp;amp;amp;amp;amp;quot;select * from dba_users&amp;amp;amp;amp;amp;amp;amp;quot; file=users.csv\r\n<\/pre>\n
    \u05e4\u05dc\u05d8 (\u05d1\u05ea\u05d5\u05da \u05d4\u05e7\u05d5\u05d1\u05e5):<\/p>\n
    \r\nZOHAR,98,,OPEN,,,USERS,TEMP,2014-02-16 01:35:12,DEFAULT,DEFAULT_CONSUMER_GROUP,,10G 11G ,N,PASSWORD\r\n<\/pre>\n
    \u05d4\u05e2\u05e8\u05d4 \u05d7\u05e9\u05d5\u05d1\u05d4!<\/h2>\n
    \u05db\u05d0\u05de\u05d5\u05e8, \u05de\u05d3\u05d5\u05d1\u05e8 \u05d1\u05d1\u05d7\u05d5\u05e8 \u05e1\u05d9\u05e0\u05d9 – \u05d4\u05d0\u05ea\u05e8 \u05e9\u05dc\u05d5 \u05e7\u05e6\u05ea \u05dc\u05d0 \u05de\u05ea\u05e4\u05e7\u05d3 (\u05db\u05de\u05e2\u05d8 \u05e2\u05dc \u05d4\u05db\u05dc \u05db\u05ea\u05d5\u05d1 Access Denied) \u05d5\u05e0\u05e8\u05d0\u05d4 \u05e9\u05d4\u05d5\u05d0 \u05dc\u05d0 \u05db\u05dc \u05db\u05da \u05de\u05e2\u05d3\u05db\u05df \u05d0\u05d5\u05ea\u05d5 (\u05e2\u05d3\u05db\u05d5\u05df \u05d0\u05d7\u05e8\u05d5\u05df \u05dc\u05e4\u05e0\u05d9 \u05e9\u05e0\u05d4 \u05d5\u05d7\u05e6\u05d9). \u05d1\u05e0\u05d5\u05e1\u05e3, \u05d0\u05e0\u05d9 \u05dc\u05d0 \u05d9\u05d5\u05d3\u05e2 \u05de\u05ea\u05d9 \u05d4\u05db\u05dc\u05d9 \u05d4\u05d6\u05d4 \u05e2\u05d5\u05d3\u05db\u05df \u05dc\u05d0\u05d7\u05e8\u05d5\u05e0\u05d4. \u05de\u05db\u05d5\u05d5\u05df \u05e9\u05e2\u05d3\u05d9\u05d9\u05df \u05de\u05d3\u05d5\u05d1\u05e8 \u05e4\u05d4 \u05e2\u05dc Oracle Ace \u05d0\u05d6 \u05d4\u05db\u05dc\u05d9 \u05d9\u05d7\u05e1\u05d9\u05ea \u05d0\u05de\u05d9\u05df \u05d1\u05e2\u05d9\u05e0\u05d9 \u05d5\u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05e9\u05ea\u05de\u05e9 \u05d1\u05d5.
    \n\u05d0\u05e0\u05d9 \u05e2\u05d5\u05d1\u05d3 \u05e2\u05dd \u05d4\u05db\u05dc\u05d9 \u05d4\u05d6\u05d4 \u05d1\u05e1\u05d1\u05d9\u05d1\u05d5\u05ea \u05e9\u05dc Oracle 11gR2 \u05dc\u05d3\u05d1\u05e8\u05d9\u05dd \u05e4\u05e9\u05d5\u05d8\u05d9\u05dd \u05d9\u05d7\u05e1\u05d9\u05ea \u05dc\u05de\u05e8\u05d5\u05ea \u05e9\u05d4\u05db\u05dc\u05d9 \u05de\u05d0\u05e4\u05e9\u05e8 \u05d2\u05dd \u05d3\u05d1\u05e8\u05d9\u05dd \u05d9\u05d5\u05ea\u05e8 \u05de\u05d5\u05e8\u05db\u05d1\u05d9\u05dd: \u05d4\u05d5\u05d0 \u05ea\u05d5\u05de\u05da \u05d1-lob-\u05d9\u05dd, \u05de\u05d0\u05e4\u05e9\u05e8 debug \u05d5\u05e9\u05dc\u05d9\u05d8\u05d4 \u05d1\u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05e9\u05dc tuning \u05d5\u05d0\u05e4\u05d9\u05dc\u05d5 \u05d7\u05dc\u05d5\u05e7\u05d4 \u05e9\u05dc \u05d4\u05e4\u05dc\u05d8 \u05dc\u05de\u05e1\u05e4\u05e8 \u05e7\u05d1\u05e6\u05d9\u05dd.
    \n\u05e9\u05d9\u05de\u05d5 \u05dc\u05d1 \u05dc\u05d1\u05d0\u05d2 \u05d4\u05d1\u05d0: \u05d0\u05dd \u05d4\u05d5\u05d0 \u05e1\u05d5\u05db\u05dd \u05e2\u05de\u05d5\u05d3\u05d4 \u05e9\u05d9\u05e9 \u05d1\u05d4 null, \u05d4\u05ea\u05d5\u05e6\u05d0\u05d4 \u05ea\u05e7\u05d9\u05e0\u05d4 \u05d0\u05d1\u05dc \u05d4\u05d0\u05e4\u05dc\u05d9\u05e7\u05e6\u05d9\u05d4 \u05d4\u05d6\u05d5 \u05e2\u05e4\u05d4…<\/p>\n
    \u05d4\u05e0\u05d4 \u05db\u05de\u05d4 \u05e7\u05d9\u05e9\u05d5\u05e8 \u05dc\u05d0\u05ea\u05e8 \u05e9\u05dc \u05d4\u05de\u05e4\u05ea\u05d7: http:\/\/www.anysql.net (\u05d1\u05e1\u05d9\u05e0\u05d9\u05ea, \u05ea\u05d5\u05d3\u05d4 \u05dc\u05d2\u05d5\u05d2\u05dc \u05d8\u05e8\u05e0\u05e1\u05dc\u05d9\u05d9\u05d8). \u05d9\u05e9 \u05e9\u05dd \u05db\u05ea\u05d5\u05d1\u05ea \u05d0\u05d9\u05de\u05d9\u05d9\u05dc \u05d5\u05d4\u05d1\u05d7\u05d5\u05e8 \u05e9\u05e4\u05d9\u05ea\u05d7 \u05d0\u05ea \u05d4\u05db\u05dc\u05d9 \u05dc\u05e4\u05e2\u05de\u05d9\u05dd \u05d0\u05e4\u05d9\u05dc\u05d5 \u05e2\u05d5\u05e0\u05d4 \u05d1\u05d5… \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u05e4\u05e2\u05dd \u05e4\u05e2\u05dd, \u05de\u05d6\u05de\u05df \u05de\u05d6\u05de\u05df, \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e4\u05d9\u05e6'\u05e8\u05d9\u05dd \u05e9\u05dc SQL*Plus \u05d5\u05d0\u05d7\u05e8\u05d9 \u05d6\u05d4 \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05d5\u05d3 \u05e4\u05d5\u05e1\u05d8 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e7\u05d5\u05d3 PL\/SQL. \u05d4\u05d9\u05d5\u05dd \u05e0\u05d3\u05d1\u05e8 \u05e2\u05dc \u05db\u05dc\u05d9 \u05d7\u05d9\u05e6\u05d5\u05e0\u05d9 (\u05d7\u05d9\u05e0\u05de\u05d9 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05dc\u05d0 \u05de\u05e1\u05d7\u05e8\u05d9) \u05e9\u05de\u05d0\u05e4\u05e9\u05e8 \u05dc\u05e0\u05d5 \u05dc\u05ea\u05ea \u05dc\u05d5 \u05de\u05e6\u05d3 \u05d0\u05d7\u05d3 \u05e9\u05dc\u05d9\u05e4\u05d4 (\u05d0\u05d5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8 \u05e2\u05dd \u05e9\u05dc\u05d9\u05e4\u05d4) \u05d5\u05de\u05e6\u05d3 \u05e9\u05e0\u05d9 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[6,168,13],"tags":[36,85,120,128,130],"class_list":["post-1148","post","type-post","status-publish","format-standard","hentry","category-oracle","category-oracle-en","category-13","tag-csv","tag-oracle-2","tag-script","tag-sqlunloader","tag-sqluldr"],"yoast_head":"\n\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/\" \/>\n<meta property=\"og:locale\" content=\"he_IL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic\" \/>\n<meta property=\"og:description\" content=\"\u05e4\u05e2\u05dd \u05e4\u05e2\u05dd, \u05de\u05d6\u05de\u05df \u05de\u05d6\u05de\u05df, \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e4\u05d9\u05e6'\u05e8\u05d9\u05dd \u05e9\u05dc SQL*Plus \u05d5\u05d0\u05d7\u05e8\u05d9 \u05d6\u05d4 \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05d5\u05d3 \u05e4\u05d5\u05e1\u05d8 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e7\u05d5\u05d3 PL\/SQL. \u05d4\u05d9\u05d5\u05dd \u05e0\u05d3\u05d1\u05e8 \u05e2\u05dc \u05db\u05dc\u05d9 \u05d7\u05d9\u05e6\u05d5\u05e0\u05d9 (\u05d7\u05d9\u05e0\u05de\u05d9 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05dc\u05d0 \u05de\u05e1\u05d7\u05e8\u05d9) \u05e9\u05de\u05d0\u05e4\u05e9\u05e8 \u05dc\u05e0\u05d5 \u05dc\u05ea\u05ea \u05dc\u05d5 \u05de\u05e6\u05d3 \u05d0\u05d7\u05d3 \u05e9\u05dc\u05d9\u05e4\u05d4 (\u05d0\u05d5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8 \u05e2\u05dd \u05e9\u05dc\u05d9\u05e4\u05d4) \u05d5\u05de\u05e6\u05d3 \u05e9\u05e0\u05d9 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Real Time DBA Magic\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:author\" content=\"https:\/\/facebook.com\/zohare\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-14T07:04:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-03-16T21:21:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2014\/12\/Facebook-Share-profile-photo-270-x-270_2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"270\" \/>\n\t<meta property=\"og:image:height\" content=\"270\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@realmgic\" \/>\n<meta name=\"twitter:site\" content=\"@realmgic\" \/>\n<meta name=\"twitter:label1\" content=\"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 \u05d3\u05e7\u05d5\u05ea\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/\"},\"author\":{\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\"},\"headline\":\"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader\",\"datePublished\":\"2014-07-14T07:04:34+00:00\",\"dateModified\":\"2017-03-16T21:21:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/\"},\"wordCount\":614,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"keywords\":[\"csv\",\"oracle\",\"script\",\"SQL*UnLoader\",\"sqluldr\"],\"articleSection\":[\"Oracle\",\"Oracle\",\"\u05e1\u05e7\u05e8\u05d9\u05e4\u05d8\"],\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/\",\"name\":\"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\"},\"datePublished\":\"2014-07-14T07:04:34+00:00\",\"dateModified\":\"2017-03-16T21:21:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/#breadcrumb\"},\"inLanguage\":\"he-IL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/sqlunloader-guide\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#website\",\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/\",\"name\":\"Real Time DBA Magic\",\"description\":\"Doing Real Time DBA Magics\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"he-IL\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/13e6cf68689bd7ea5f6556f5246e6175\",\"name\":\"Zohar Elkayam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\",\"caption\":\"Zohar Elkayam\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/#\\\/schema\\\/person\\\/fef9c8983df7a5ec53d0e2c733148334\",\"name\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"he-IL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g\",\"caption\":\"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd\"},\"sameAs\":[\"https:\\\/\\\/zoharelkayam.me\",\"https:\\\/\\\/facebook.com\\\/zohare\",\"https:\\\/\\\/x.com\\\/realmgic\"],\"url\":\"https:\\\/\\\/www.realdbamagic.com\\\/he\\\/author\\\/zohar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/","og_locale":"he_IL","og_type":"article","og_title":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic","og_description":"\u05e4\u05e2\u05dd \u05e4\u05e2\u05dd, \u05de\u05d6\u05de\u05df \u05de\u05d6\u05de\u05df, \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e4\u05d9\u05e6'\u05e8\u05d9\u05dd \u05e9\u05dc SQL*Plus \u05d5\u05d0\u05d7\u05e8\u05d9 \u05d6\u05d4 \u05db\u05ea\u05d1\u05ea\u05d9 \u05e2\u05d5\u05d3 \u05e4\u05d5\u05e1\u05d8 \u05e2\u05dc \u05d0\u05d9\u05da \u05e0\u05d9\u05ea\u05df \u05dc\u05d9\u05d9\u05e6\u05e8 \u05e7\u05d1\u05e6\u05d9 CSV \u05e2\u05dc \u05d9\u05d3\u05d9 \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e7\u05d5\u05d3 PL\/SQL. \u05d4\u05d9\u05d5\u05dd \u05e0\u05d3\u05d1\u05e8 \u05e2\u05dc \u05db\u05dc\u05d9 \u05d7\u05d9\u05e6\u05d5\u05e0\u05d9 (\u05d7\u05d9\u05e0\u05de\u05d9 \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05dc\u05d0 \u05de\u05e1\u05d7\u05e8\u05d9) \u05e9\u05de\u05d0\u05e4\u05e9\u05e8 \u05dc\u05e0\u05d5 \u05dc\u05ea\u05ea \u05dc\u05d5 \u05de\u05e6\u05d3 \u05d0\u05d7\u05d3 \u05e9\u05dc\u05d9\u05e4\u05d4 (\u05d0\u05d5 \u05e1\u05e7\u05e8\u05d9\u05e4\u05d8 \u05e2\u05dd \u05e9\u05dc\u05d9\u05e4\u05d4) \u05d5\u05de\u05e6\u05d3 \u05e9\u05e0\u05d9 […]","og_url":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/","og_site_name":"Real Time DBA Magic","article_publisher":"https:\/\/facebook.com\/zohare","article_author":"https:\/\/facebook.com\/zohare","article_published_time":"2014-07-14T07:04:34+00:00","article_modified_time":"2017-03-16T21:21:53+00:00","og_image":[{"width":270,"height":270,"url":"https:\/\/www.realdbamagic.com\/wp-content\/uploads\/2014\/12\/Facebook-Share-profile-photo-270-x-270_2.png","type":"image\/png"}],"author":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","twitter_card":"summary_large_image","twitter_creator":"@realmgic","twitter_site":"@realmgic","twitter_misc":{"\u05e0\u05db\u05ea\u05d1 \u05e2\u05dc \u05d9\u05d3":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","\u05d6\u05de\u05df \u05e7\u05e8\u05d9\u05d0\u05d4 \u05de\u05d5\u05e2\u05e8\u05da":"3 \u05d3\u05e7\u05d5\u05ea"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/#article","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/"},"author":{"name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334"},"headline":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader","datePublished":"2014-07-14T07:04:34+00:00","dateModified":"2017-03-16T21:21:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/"},"wordCount":614,"commentCount":2,"publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"keywords":["csv","oracle","script","SQL*UnLoader","sqluldr"],"articleSection":["Oracle","Oracle","\u05e1\u05e7\u05e8\u05d9\u05e4\u05d8"],"inLanguage":"he-IL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/","url":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/","name":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader - Real Time DBA Magic","isPartOf":{"@id":"https:\/\/www.realdbamagic.com\/he\/#website"},"datePublished":"2014-07-14T07:04:34+00:00","dateModified":"2017-03-16T21:21:53+00:00","breadcrumb":{"@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/#breadcrumb"},"inLanguage":"he-IL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.realdbamagic.com\/he\/sqlunloader-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.realdbamagic.com\/he\/"},{"@type":"ListItem","position":2,"name":"\u05de\u05d3\u05e8\u05d9\u05da \u05dc\u05d9\u05e6\u05d9\u05e8\u05ea \u05e7\u05d5\u05d1\u05e5 CSV \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea SQL*UnLoader"}]},{"@type":"WebSite","@id":"https:\/\/www.realdbamagic.com\/he\/#website","url":"https:\/\/www.realdbamagic.com\/he\/","name":"Real Time DBA Magic","description":"Doing Real Time DBA Magics","publisher":{"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.realdbamagic.com\/he\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"he-IL"},{"@type":["Person","Organization"],"@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/13e6cf68689bd7ea5f6556f5246e6175","name":"Zohar Elkayam","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g","caption":"Zohar Elkayam"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/6b35de11903784dc7095933d7c48e0508b11bb277a2a3f4fe58d43f868e2260b?s=96&d=monsterid&r=g"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"]},{"@type":"Person","@id":"https:\/\/www.realdbamagic.com\/he\/#\/schema\/person\/fef9c8983df7a5ec53d0e2c733148334","name":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd","image":{"@type":"ImageObject","inLanguage":"he-IL","@id":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b5c39e9d46112c05384eec046632222fbe1d0bb2af3d452e44e29b6f3956eeea?s=96&d=monsterid&r=g","caption":"\u05d6\u05d4\u05e8 \u05d0\u05dc\u05e7\u05d9\u05d9\u05dd"},"sameAs":["https:\/\/zoharelkayam.me","https:\/\/facebook.com\/zohare","https:\/\/x.com\/realmgic"],"url":"https:\/\/www.realdbamagic.com\/he\/author\/zohar\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p5e40u-iw","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/comments?post=1148"}],"version-history":[{"count":13,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1148\/revisions"}],"predecessor-version":[{"id":2526,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/posts\/1148\/revisions\/2526"}],"wp:attachment":[{"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/media?parent=1148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/categories?post=1148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.realdbamagic.com\/he\/wp-json\/wp\/v2\/tags?post=1148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}