{"id":1823,"date":"2011-04-17T13:37:25","date_gmt":"2011-04-17T13:37:25","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/sql-loader"},"modified":"2014-12-23T09:05:34","modified_gmt":"2014-12-23T09:05:34","slug":"sql-loader","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader","title":{"rendered":"SQL Loader Part 1"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called log file, bad file or reject file, discard file.<\/p>\n<ul>\n<li><span style=\"text-decoration: underline;\">Log file<\/span> tells you the state of the tables and indexes and the number of logical records already read from the input datafile. This information can be used to resume the load where it left off.<\/li>\n<li><span style=\"text-decoration: underline;\"> Bad file<\/span> or reject file gives you the records that were rejected because of formatting errors or because they caused Oracle errors.<\/li>\n<li><span style=\"text-decoration: underline;\">Discard file<\/span> specifies the records that do not meet any of the loading criteria like when any of the WHEN clauses specified in the control file. These records differ from rejected records.<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline;\">Structure of the data file:<\/span><\/p>\n<p>The data file can be in fixed record format or variable record format.<\/p>\n<p>Fixed Record Format would look like the below. In this case you give a specific position where the Control file can expect a data field:<\/p>\n<p>7369 SMITH\u00a0\u00a0\u00a0\u00a0 \u00a0CLERK\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a07902 \u00a012\/17\/1980\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 800<\/p>\n<p>7499 ALLEN\u00a0\u00a0\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698 \u00a02\/20\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01600<\/p>\n<p>7521 WARD\u00a0\u00a0\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698 \u00a02\/22\/1981\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01250<\/p>\n<p>7566 JONES\u00a0\u00a0\u00a0\u00a0 \u00a0MANAGER\u00a0\u00a0 7839 \u00a04\/2\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a02975<\/p>\n<p>7654 MARTIN\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698 \u00a09\/28\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01250<\/p>\n<p>7698 BLAKE\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839 \u00a05\/1\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a02850<\/p>\n<p>7782 CLARK\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839 \u00a06\/9\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a02450<\/p>\n<p>7788 SCOTT\u00a0\u00a0\u00a0\u00a0 \u00a0ANALYST\u00a0\u00a0 \u00a07566 \u00a012\/9\/1982\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a03000<\/p>\n<p>7839 KING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0PRESIDENT \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a011\/17\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5000<\/p>\n<p>7844 TURNER\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698 \u00a09\/8\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a01500<\/p>\n<p>7876 ADAMS\u00a0\u00a0\u00a0\u00a0 CLERK\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a07788 \u00a01\/12\/1983\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1100<\/p>\n<p>7900 JAMES\u00a0\u00a0\u00a0\u00a0\u00a0 CLERK\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a07698 \u00a012\/3\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 950<\/p>\n<p>7902 FORD\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0ANALYST\u00a0\u00a0 \u00a0\u00a07566 \u00a012\/3\/1981\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3000<\/p>\n<p>7934 MILLER\u00a0\u00a0\u00a0\u00a0 CLERK\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a07782 \u00a01\/23\/1982\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1300<\/p>\n<p>Variable Record Format would like below where the data fields are separated by a delimiter.<\/p>\n<p><span style=\"text-decoration: underline;\"> Note:<\/span> The Delimiter can be anything you like. In this case it is &#8220;|&#8221;<\/p>\n<p>1196700|9|0|692.64<\/p>\n<p>1378901|2|3900|488.62<\/p>\n<p>1418700|2|2320|467.92<\/p>\n<p>1418702|14|8740|4056.36<\/p>\n<p>1499100|1|0|3.68<\/p>\n<p>1632800|3|0|1866.66<\/p>\n<p>1632900|1|70|12.64<\/p>\n<p>1637600|50|0|755.5<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Structure of a Control file:<\/span><\/p>\n<p>Sample CTL file for loading a Variable record data file:<\/p>\n<pre>OPTIONS (SKIP = 1)\u00a0\u00a0 --The first row in the data file is skipped without loading\r\n\r\nLOAD DATA\r\n\r\nINFILE '$FILE'\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- Specify the data file \u00a0path and name\r\n\r\nAPPEND\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- type of loading (INSERT, APPEND, REPLACE, TRUNCATE\r\n\r\nINTO TABLE \"APPS\".\"BUDGET\"\u00a0\u00a0 -- the table to be loaded into\r\n\r\nFIELDS TERMINATED BY '|'\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -- Specify the delimiter if variable format datafile\r\n\r\nOPTIONALLY ENCLOSED BY '\"'\u00a0\u00a0 --the values of the data fields may be enclosed in \"\r\n\r\nTRAILING NULLCOLS\u00a0\u00a0\u00a0\u00a0 -- columns that are not present in the record treated as null\r\n\r\n(ITEM_NUMBER\u00a0\u00a0\u00a0 \"TRIM(:ITEM_NUMBER)\", -- Can use all SQL functions on columns\r\n\r\nQTY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL EXTERNAL,\r\n\r\nREVENUE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL EXTERNAL,\r\n\r\nEXT_COST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL EXTERNAL TERMINATED BY WHITESPACE \"(TRIM(:EXT_COST))\"\u00a0 ,\r\n\r\nMONTH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"to_char(LAST_DAY(ADD_MONTHS(SYSDATE,-1)),'DD-MON-YY')\" ,\r\n\r\nDIVISION_CODE\u00a0\u00a0\u00a0 CONSTANT \"AUD\"\u00a0 -- Can specify constant value instead of Getting value from datafile\r\n\r\n)<\/pre>\n<p>OPTION statement precedes the LOAD DATA statement. The OPTIONS parameter allows you to specify runtime arguments in the control file, rather than on the command line. The following arguments can be specified using the OPTIONS parameter.<\/p>\n<p>SKIP = n &#8212; Number of logical records to skip (Default 0)<\/p>\n<p>LOAD = n &#8212; Number of logical records to load (Default all)<\/p>\n<p>ERRORS = n &#8212; Number of errors to allow (Default 50)<\/p>\n<p>ROWS = n\u00a0\u00a0 &#8212; Number of rows in conventional path bind array or between direct path data saves (Default: Conventional Path 64, Direct path all)<\/p>\n<p>BINDSIZE = n &#8212; Size of conventional path bind array in bytes (System-dependent default)<\/p>\n<p>SILENT = {FEEDBACK | ERRORS | DISCARDS | ALL} &#8212; Suppress messages during run<\/p>\n<p>(header, feedback, errors, discards, partitions, all)<\/p>\n<p>DIRECT = {TRUE | FALSE} &#8211;Use direct path (Default FALSE)<\/p>\n<p>PARALLEL = {TRUE | FALSE} &#8212; Perform parallel load (Default FALSE)<\/p>\n<p>LOADDATA statement is required at the beginning of the control file.<\/p>\n<p>INFILE: INFILE keyword is used to specify location of the datafile or datafiles.<\/p>\n<p>INFILE* specifies that the data is found in the control file and not in an external file. INFILE &#8216;$FILE&#8217;, can be used to send the filepath and filename as a parameter when registered as a concurrent program.<\/p>\n<p>INFILE\u00a0\u00a0 &#8216;\/home\/vision\/kap\/import2.csv&#8217; specifies the filepath and the filename.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Example where datafile is an external file:<\/span><\/p>\n<p>LOAD DATA<\/p>\n<p>INFILE\u00a0\u00a0 &#8216;\/home\/vision\/kap\/import2.csv&#8217;<\/p>\n<p>INTO TABLE kap_emp<\/p>\n<p>FIELDS TERMINATED BY &#8220;,&#8221;<\/p>\n<p>( emp_num, emp_name, department_num, department_name )<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Example where datafile is in the Control file:<\/span><\/p>\n<p>LOAD DATA<\/p>\n<p>INFILE *<\/p>\n<p>INTO TABLE kap_emp<\/p>\n<p>FIELDS TERMINATED BY &#8220;,&#8221;<\/p>\n<p>( emp_num, emp_name, department_num, department_name )<\/p>\n<p>BEGINDATA<\/p>\n<p>7369,SMITH,7902,Accounting<\/p>\n<p>7499,ALLEN,7698,Sales<\/p>\n<p>7521,WARD,7698,Accounting<\/p>\n<p>7566,JONES,7839,Sales<\/p>\n<p>7654,MARTIN,7698,Accounting<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Example where file name and path is sent as a parameter when registered as a concurrent program<\/span><\/p>\n<p>LOAD DATA<\/p>\n<p>INFILE &#8216;$FILE&#8217;<\/p>\n<p>INTO TABLE kap_emp<\/p>\n<p>FIELDS TERMINATED BY &#8220;,&#8221;<\/p>\n<p>( emp_num, emp_name, department_num, department_name )<\/p>\n<p>TYPE OF LOADING:<\/p>\n<p>INSERT\u00a0\u00a0 &#8212; If the table you are loading is empty, INSERT can be used.<\/p>\n<p>APPEND\u00a0 &#8212; If data already exists in the table, SQL*Loader appends the new rows to it. If data doesn&#8217;t already exist, the new rows are simply loaded.<\/p>\n<p>REPLACE &#8212; All rows in the table are deleted and the new data is loaded<\/p>\n<p>TRUNCATE &#8212; SQL*Loader uses the SQL TRUNCATE command.<\/p>\n<p>INTOTABLEis required to identify the table to be loaded into. In the above example INTO TABLE &#8220;APPS&#8221;.&#8221;BUDGET&#8221;, APPS refers to the Schema and BUDGET is the Table name.<\/p>\n<p>FIELDS TERMINATED BY specifies how the data fields are terminated in the datafile.(If the file is Comma delimited or Pipe delimited etc)<\/p>\n<p>OPTIONALLY ENCLOSED BY &#8216;&#8221;&#8216; specifies that data fields may also be enclosed by quotation marks.<\/p>\n<p>TRAILINGNULLCOLS clause tells SQL*Loader to treat any relatively positioned columns that are not present in the record as null columns.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Loading a fixed format data file:<\/span><\/p>\n<p>LOAD DATA<\/p>\n<p>INFILE &#8216;sample.dat&#8217;<\/p>\n<p>INTO TABLE emp<\/p>\n<p>( empno\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(01:04)\u00a0\u00a0 INTEGER EXTERNAL,<\/p>\n<p>ename\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(06:15)\u00a0\u00a0 CHAR,<\/p>\n<p>job\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(17:25)\u00a0\u00a0 CHAR,<\/p>\n<p>mgr\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(27:30)\u00a0\u00a0 INTEGER EXTERNAL,<\/p>\n<p>sal\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(32:39)\u00a0\u00a0 DECIMAL EXTERNAL,<\/p>\n<p>comm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(41:48)\u00a0\u00a0 DECIMAL EXTERNAL,<\/p>\n<p>deptno\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(50:51)\u00a0\u00a0 INTEGER EXTERNAL)<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Steps to Run the SQL* LOADER from UNIX:<\/span><\/p>\n<p>At the prompt, invoke SQL*Loader as follows:<\/p>\n<p>sqlldr USERID=scott\/tiger CONTROL=&lt;control filename&gt; LOG=&lt;Log file\u00a0name&gt;<\/p>\n<p>SQL*Loader loads the tables, creates the log file, and returns you to the system prompt. You can check the log file to see the results of running the case study.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Register as concurrent Program:<\/span><\/p>\n<p>Place the Control file in $CUSTOM_TOP\/bin.<\/p>\n<p>Define the Executable. Give the Execution Method as SQL*LOADER.<\/p>\n<p>Define the Program. Add the Parameter for FILENAME.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Skip columns:<\/span><\/p>\n<p>You can skip columns using the &#8216;FILLER&#8217; option.<\/p>\n<p>Load Data<br \/>\n&#8212;<br \/>\n&#8212;<br \/>\n&#8212;<br \/>\nTRAILING\u00a0 NULLCOLS<br \/>\n(<br \/>\nname Filler,<br \/>\nEmpno ,<br \/>\nsal<br \/>\n)<\/p>\n<p>here the column name will be skipped.<\/p>\n<p>Please continue to read our part-2 of SQL Loader article<br \/>\n<a href=\"http:\/\/erpschools.com\/tools\/sql-loader-part-2\" title=\"SQL Loader Part-2\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called log [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[80],"tags":[],"class_list":["post-1823","post","type-post","status-publish","format-standard","hentry","category-sql-loader"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>oracle apps sql loader<\/title>\n<meta name=\"description\" content=\"oracle apps sql loader to load data from file to table\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"SQL Loader Part 1\",\"datePublished\":\"2011-04-17T13:37:25+00:00\",\"dateModified\":\"2014-12-23T09:05:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\"},\"wordCount\":923,\"commentCount\":34,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"articleSection\":[\"SQL Loader\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\",\"url\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\",\"name\":\"oracle apps sql loader\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"datePublished\":\"2011-04-17T13:37:25+00:00\",\"dateModified\":\"2014-12-23T09:05:34+00:00\",\"description\":\"oracle apps sql loader to load data from file to table\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Loader Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oracle apps sql loader","description":"oracle apps sql loader to load data from file to table","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:\/\/erpschools.com\/erps\/sql-loader\/sql-loader","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"SQL Loader Part 1","datePublished":"2011-04-17T13:37:25+00:00","dateModified":"2014-12-23T09:05:34+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader"},"wordCount":923,"commentCount":34,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"articleSection":["SQL Loader"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader","url":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader","name":"oracle apps sql loader","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"datePublished":"2011-04-17T13:37:25+00:00","dateModified":"2014-12-23T09:05:34+00:00","description":"oracle apps sql loader to load data from file to table","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/sql-loader\/sql-loader#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"SQL Loader Part 1"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1823"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1823\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}