Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

36.2 Create a table in the database to hold the TOC data

The steps in this section will show you how to create a table in the database that will hold the page numbers for the main and sub-categories in the report. If you are not sure if you can create a table in the database, contact the database administrator.

To create a table in the database:

  1. Start SQL*Plus.

    • On Windows, from the Start menu, choose Programs > Oracle Application Server - oracle_home_name > Application Development > SQL Plus.

    • On UNIX, type sqlplus.

  2. Connect to the Sales History schema of the database (for example, use the sh/sh@database_name connect string).

  3. At the SQL prompt, type the following line:

    create table toc_multilevel (main_topic varchar2(100), sub_topic varchar2(100), page number);
  4. Press Enter.

    You should see a notification that the table has been created.

  5. Exit SQL*Plus.