Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    5

    Post Unanswered: shell script to .sql files

    hi Friends,
    i am new to oracle.
    i have to write one shell script to run .sql file and need export the data in to .xls with header and with out trimming any column name and column value.
    result sql may contain 60000 records.
    Please help me in this regard...
    thanks in advance...
    -Bali

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Please realize this is a FAQ & GOOGLE works for many folks.
    Please realize that "shell script" are very Operating System dependent & you decided we did not need to know your OS.

    Understand that via ODBC Excel can directly "extract" data from Oracle DB.
    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.

  3. #3
    Join Date
    Mar 2009
    Posts
    5
    OS is Solaris

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Does this script have to work for any/every table, any/every datatype, & variable number of columns?
    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.

  5. #5
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    Quote Originally Posted by balireddy_77
    hi Friends,
    i am new to oracle.
    i have to write one shell script to run .sql file and need export the data in to .xls with header and with out trimming any column name and column value.
    result sql may contain 60000 records.
    Please help me in this regard...
    thanks in advance...
    -Bali

    You can open the .sql file with ORACLE SQL DEVELOPER . Run the sql . the result can be export in .xl with header
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

Posting Permissions

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