Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Report Generating

    Hi, Guys!

    I am a newbit to Oracle.

    Recently I would like to generate a report based on results of SQL statements and PL/SQL, but i don't know which ultilities I should use, coz there are UTL_file and SPOOL.

    With UTL_FILE, I don't have access to create a utl_file_dir and i am only allowed to connect to the system as normal users. I have tried use SPOOL, but it always give me the commands that i input before i close the spool.

    Thanx in advanced

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    SPOOL will work. There are various SQL Plus SET command options you can use to clean up the output, like these:

    SET PAGESIZE 0
    SET LINES 132
    SET FEEDBACK OFF
    SET VERIFY OFF
    SET ECHO OFF

    See the SQL Plus documentation for full details of the SET command.

Posting Permissions

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