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:
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
.
Connect to the Sales History schema of the database (for example, use the sh/sh@
database_name connect string).
At the SQL prompt, type the following line:
create table toc_multilevel (main_topic varchar2(100), sub_topic varchar2(100), page number);
Press Enter.
You should see a notification that the table has been created.
Exit SQL*Plus.