User`s guide

iv
2.2.2.2 Transferring Data by File Transfer............................................................................. 2-3
2.3 The Import Utility....................................................................................................................... 2-3
2.3.1 Starting the Import Utility.................................................................................................. 2-4
2.3.2 Importing from Foreign Systems ...................................................................................... 2-4
2.3.2.1 Import File Block Size .................................................................................................. 2-4
2.3.2.2 Transferring Data by Tape .......................................................................................... 2-4
2.3.2.3 Transferring Data by File Transfer............................................................................. 2-4
2.4 The Data Pump Export Utility .................................................................................................. 2-4
2.4.1 Starting the Data Pump Export Utility............................................................................ 2-4
2.5 The Data Pump Import Utility.................................................................................................. 2-5
2.5.1 Starting the Data Pump Import Utility............................................................................. 2-5
2.6 Oracle Text Loader...................................................................................................................... 2-5
3 SQL*Plus
3.1 Running SQL*Plus...................................................................................................................... 3-1
3.1.1 SQL*Plus User Profiles........................................................................................................ 3-1
3.1.1.1 The GLOGIN.SQL Global Startup File...................................................................... 3-2
3.1.1.2 The LOGIN.SQL User Startup File ............................................................................ 3-2
3.1.2 Starting SQL*Plus ............................................................................................................... 3-2
3.1.3 Interrupting SQL*Plus ....................................................................................................... 3-2
3.1.4 Issuing BS2000 Commands from SQL*Plus..................................................................... 3-3
3.1.5 Starting the BS2000 Editor ................................................................................................. 3-3
3.1.6 The SQL ASCII Function ................................................................................................... 3-4
3.1.7 Spooling SQL*Plus Output................................................................................................. 3-4
3.1.8 Using SQL*Plus Symbols.................................................................................................... 3-4
3.2 Specifying the Search Path for SQL*Plus Command Files ................................................... 3-4
3.3 Sample Schemas and SQL*Plus ................................................................................................ 3-5
3.4 SQL*Plus Limits .......................................................................................................................... 3-5
3.5 Using SQL*Plus in the POSIX environment ........................................................................... 3-5
3.5.1 Starting SQL*Plus ................................................................................................................ 3-6
3.5.2 Running Shell Commands From SQL*Plus..................................................................... 3-6
3.5.3 Using an Editor in SQL*plus.............................................................................................. 3-6
4 PL/SQL
4.1 PL/SQL Demonstrations ........................................................................................................... 4-1
4.1.1 PL/SQL Demos for the Kernel .......................................................................................... 4-1
4.1.2 PL/SQL Demos for Precompilers ..................................................................................... 4-2
5 Programmatic Interfaces
5.1 Overview...................................................................................................................................... 5-1
5.1.1 Architecture of the Programmatic Interfaces................................................................... 5-1
5.1.2 PL/SQL ................................................................................................................................. 5-2
5.2 Building and Running a Programmatic Interface Application............................................ 5-2
5.2.1 Existing Applications .......................................................................................................... 5-3
5.2.2 Precompilers......................................................................................................................... 5-3
5.2.2.1 Include Files................................................................................................................... 5-4