Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    6

    Question Unanswered: How to read Excel from PL/SQL?

    Can you anyone tell me how to read the first column of Excel file and display the same using PL/SQL?

    For example: Excel file contains

    Employee id:
    1
    2
    3
    4
    5

    Instead of using the following SQL command in PL/SQL
    select * from ps_vendor a
    where a.setid = '007' and a.vendor_id in ('1', '2', '3', '4', '5');

    I would like to open the excel file read it and provide the same as input in the sql statement.

    Any idea??

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I moved your thread from Adabas to Oracle. You're much more likely to get useful answers here.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Dec 2010
    Location
    United States
    Posts
    1

    Smile

    Thanks...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •