How to store Multiple Ec\xcels into Table Using sql loder

10-11  Source: Network gathering  Views:0 

Advertisement
Plese guide me to store Multiple Ec\xcels into Table Using sql loder
I am not clear with your question. Do you want to load multipel Excel Files into a table. If so you can follow this link.
http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_load_data_from_multiple_files.2F_into_multiple_tables_at_once.3F
Thanks,
Karthick.
Related articles
  • How to store Multiple Ec\xcels into Table Using sql loder 10-11

    Plese guide me to store Multiple Ec\xcels into Table Using sql loderI am not clear with your question. Do you want to load multipel Excel Files into a table. If so you can follow this link. http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_load_data_

  • How to Load Multiple Files in Oracle Database using Sql Loader 10-11

    Hi All, I want to import multiple files in my DB using Sql*Loader. Please tell me the Syntax, how can I import multiple files using one Control File? Thanks & Regards, ImranHi, You might get a good response to your post in the forum dedicated to data

  • How to Store an XML Data into Table? 10-11

    Hi All, My Requirement is "I Have an XML File (or) XML Data as CLOB, now I should decode this XML Data and find the equivalent data for columns in a table and then store that in a relational table", Would be greatful if any one can provide me a

  • How to Query Multiple Fields from different Tables using Toplink Expression 11-30

    Hi, I am trying to prepare an Oracle Toplink Expression to qurey the multiple columns of different tables. the query as following. Please can anyone help? SELECT CYCLE.CYCLE_ID, CYCLE.ASPCUSTOMER_ID, CYCLE.FACILITYHEADER_ID, CYCLE.ADDUSER, ASP.FIRSTN

  • Upload multiple excel files into tables using APEX 10-11

    Hi folks, I'm wondering if anyone has ever uploaded multiple .csv files simultaniously and store the data into the database using APEX XE before. I can browse for a single file, and execute that okay and a good example of doing that can be found at h

  • How to update multiple records in the table using POST parameters: 10-11

    i got this idea from this website:http://www.karlrixon.co.uk/articles/sql/update-multiple-rows-with-different-values-and-a-s ingle-sql-query/comment-page-1/#comment-5409. Basically i am trying to update all the status in the results page, and by addi

  • How to update multiple records in a table using procedure? 10-11

    Dear All, 1 am using 11.1.2.1.0 my question is i have a table like emp id(primary key), empname,location 1                             damby      blore 2                             rocky       kormangala 3                              biswa     indi

  • How to update multiple records in custom table using checkbox in APEX 4.1? 10-11

    Hi, I have a SQL report which brings up all the data records using the following query. select "REC_NO" AS hidden_rec_no, "REC_NO", APEX_ITEM.CHECKBOX (3,rec_no) AS edit, "MEETING_TYPE", "PAGE_NO", "CHECKBOX&qu

  • Extract Data from XML and Load into table using SQL*Loader 11-30

    Hi All, We have a XML file (sample.xml) which contains credit card transaction information. We have a standard SQL*Loader control file which loads the data from a flat file and the control file code is written as position based method. Our requiremen

  • How can I group student scores into quintile using SQL Server 2008 11-30

    Can anyone help me to group student scores into quintile. I think there is a feature in SQL Server 2012, but still we are have not upgrade to it as we are using 2008R2. I tried Ntile(5) but it not generating the desired result. I need below Quintile

  • How to delete a single data from table using control file 10-11

    I want delete a single row data from table using sql loder control file Edited by: 977940 on Dec 19, 2012 9:00 PM977940 wrote: I want delete a single row data from table using sql loder control file Edited by: 977940 on Dec 19, 2012 9:00 PMWhy? And h

  • Insert data file name into table from sql loader 11-30

    Hi All, I have a requirement to insert the data file name dynamically into table using sql loader. Example: sqlldr userid=username/[email protected]_string control=test_ctl.ctl data=test_data.dat test_ctl.ctl LOAD DATA FILED TERMINATED BY ',' INTO TABLE

  • How to store array of data into a single row of  table ,using any of Stmts 10-11

    HI Friends, Based on my requirements ,i have retrived a set of data from a XXX.jsp page using a request.getParameter() and stored into single dimenssional array . Now i am paassing that array to JAVA class to store a into some table . In JSP page use

  • How to store output of SQ01 into internal table. 10-11

    Hello Experts How to store output of SQ01 into internal table. Thanks, UmeshYou can't store the sq01 output into internal table. Once you create the query it will generate the abap program, in that program you can see the contents. Regards SasiRead o

  • How to store multiple files from SAp in to Application server? 10-11

    Hi Guys,              Can anybody tell me how to store multiple files from SAP into Application server.in my application i have to get the data from SAP tables BSEG , BKPF , BSAK and BSIK that to daily i have to do.             Any Logic  or Code for

  • How can one  read a Excel File and Upload into Table using Pl/SQL Code. 10-11

    How can one read a Excel File and Upload into Table using Pl/SQL Code. 1. Excel File is on My PC. 2. And I want to write a Stored Procedure or Package to do that. 3. DataBase is on Other Server. Client-Server Environment. 4. I am Using Toad or PlSql

  • How can I load data into table with SQL*LOADER 10-11

    how can I load data into table with SQL*LOADER when column data length more than 255 bytes? when column exceed 255 ,data can not be insert into table by SQL*LOADER CREATE TABLE A ( A VARCHAR2 ( 10 ) , B VARCHAR2 ( 10 ) , C VARCHAR2 ( 10 ) , E VARCHAR

  • How to populate multiple entries to Bapi Table 10-11

    Hi all,   How to populate multiple entries to Bapi Table..... Here is the code(in component controller)   Z_Recr_Apply_Point_Input request = new Z_Recr_Apply_Point_Input(WDModelScopeType.TASK_SCOPE);        int  size = wdContext.nodeApplicants().size

  • In  a SQL query whihc has join, How to reduce Multiple instance of a table 10-11

    in a SQL query which has join, How to reduce Multiple instance of a table Here is an example: I am using Oracle 9i is there a way to reduce no.of Person instances from the following query? or can I optimize this query further? TABLES: mail_table mail

  • How to import multiple vcard contacts into iphone4 10-11

    How to import multiple vcard contacts into iphone4I had a Nokia C6-01 and had to import the contacts to my Iphone 4S. This is how I did it 1. Open Nokia Suite and Click on Contacts 2. Select all contacts. Click on File -> Import Contacts .Specify the