Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

• %ROWTYPE attribute
• %TYPE attribute [2]
• & (symbol explained)

  A

• [ ], (symbols explained)
• Administration Utility
  • navigating to
  • structure of
  • to edit Web Listener configuration files
  • Web Listener security assignments using
• Advanced Configuration button
• aliases [2] [3]
  • domain names for machine names
  • for database objects
  • for database tables
  • for paths
• ALTER TRIGGER statement (SQL)
• anchors
  • structure of
  • used in hypertext linking
• applications programming, PL/SQL used for
• arrays, implemented as tables in PL/SQL
• assignments
  • initial
  • values to parameters (PL/SQL)
  • values to variables (PL/SQL)
• authorization schemes
• automatic recompilation (PL/SQL)

  B

• Basic Authentication [2] [3] [4]
• Basic Configuration button
• blocks (PL/SQL) [2]
• Boolean logic
  • IF statements and (PL/SQL)
  • Three-Valued in SQL

  C

• cattributes
• cattributes parameter, use in passing exact text
• CGI
• CGI Application Execution
• CGI scripts, how flagged
• Change OWA Database User Password
• changes, viewing in HTML document
• character sets
  • default
  • international
• columns [2]
  • of database tables
• Common Gateway Interface
• compiler directives (PL/SQL)
• Configuration Directory
  • changing
• configuration files, Web Listener
• Configure button
• Configure Extended Parameters Form
• Confirm Password
• connections, to the database
• constants, declaring (PL/SQL)
• constraints (SQL)
• Copy Service button
• correlation variables
  • in SQL statements
  • in triggers
• CREATE FUNCTION statement (SQL)
• Create OWA Database User
• CREATE PACKAGE BODY statement (SQL)
• CREATE PACKAGE statement (SQL)
• CREATE PROCEDURE privilege (SQL) [2]
• CREATE PROCEDURE statement (SQL)
• CREATE TABLE statement (SQL)
• cursor variables (PL/SQL) [2]
• cursors (PL/SQL)
  • in package specifications

  D

• Data Dictionary
• data structures, in PL/SQL
• database links
• databases
  • adminstering from Administration Utility
  • changing data content of
  • connecting multiple
  • connecting to [2]
  • constraining
  • creating objects in using PL/SQL
  • creating tables in
  • database triggers
  • distributed
  • interfacing to
  • keys used in
  • local [2]
  • missing data in
  • nulls used in
  • referencing objects in
  • relational
  • remote [2]
  • removing data from
  • retrieving data from
  • shutting down
  • specifying location of
  • starting up
  • storing code in [2] [3] [4]
  • structure of [2]
  • unique identifiers in
  • users of
• datatypes
  • composite
  • converting
  • inheritance of (PL/SQL)
  • PL/SQL
  • pointer
  • RECORD (PL/SQL)
  • scalar
  • SQL
    • complex data
    • LONG RAW
  • structured
  • TABLE (PL/SQL)
  • user-defined
    • PL/SQL records
    • PL/SQL tables
• dblinks
• DBMS
• DBMS_SQL package
• DBMSSTDX.SQL script
• declarations
  • constants (PL/SQL)
  • subprograms (PL/SQL)
  • types (PL/SQL)
  • variable (PL/SQL)
• DECLARE section (PL/SQL)
• Delete Service button
• DELETE statement (SQL)
• Developer's Toolkit [2]
  • installing
  • procedures and functions
• Digest Authentication [2] [3] [4]
• Directory Mappings
• distributed databases [2]
• DNS Resolution
• Domain Name Based Restriction
• domain names
  • as aliases for machine names
  • resolved to IP addresses
  • security based on
• Domain-based restriction [2]
• dot notation
  • for database objects
  • for PL/SQL objects and subprograms [2]

  E

• encoding, how indicated
• Error File Name
• error handling
  • HTML
  • location of files
  • log file name
  • log files used for
  • Oracle7
  • PL/SQL
  • return codes
  • system errors
  • triggers and
• exceptions (PL/SQL) [2] [3]
  • declared in DECLARE section
  • declaring
  • predefined
  • user-defined
• EXECUTABLE section (PL/SQL)
• EXECUTE privilege (SQL) [2]
• EXIT statement (PL/SQL)

  F

• fields
  • alternate name for database columns
  • in PL/SQL records
• File Cache
• files
  • caching of
  • encoded
• flow control (PL/SQL)
• FOR loops (PL/SQL)
• FOR UPDATE clause (PL/SQL)
• forced line breaks
• foreign keys [2]
  • joins using
• Form tags
  • Input
  • TextArea
• Forms
  • selection menus
  • syntax
• FTP
• functions [2]
  • grouped into packages
  • return values of (PL/SQL)
  • storing in database

  G

• GOTO statement (PL/SQL)
  • error handling and
• graphics
  • as hypertext buttons
  • within HTML documents
• Group ID [2]

  H

• Host Address
• Host Name [2]
• HTF
• HTML error page
• HTML Tags
  • ADDRESS
  • BLOCKQUOTE
  • BODY
  • BOLD
  • CAPTION
  • definition list
  • escape sequence
  • getting started
  • HEAD
  • heading level
  • I
  • lists
  • mono spaced
  • nested list
  • ordered list
  • P
  • PRE
  • TABLE
  • TD
  • TH
  • TITLE
  • TR
  • U
  • unordered list
• HTML
  • basic concepts
  • case sensitivity
  • error handling
  • introduction
  • multi-button graphics
• HTP
• HTTP
• HyperText Functions, description of
• HyperText Markup Language
• HyperText Procedures
  • body tags
  • character format tags
  • definition of
  • description of
  • form tags
  • head-related tags
  • list tags
  • physical format tags
  • printing procedures
  • structural tags (HTML)
  • table tags

  I

• Identified by
  • defined
  • radio button
• IF statement (PL/SQL)
• Image Map
• imagemap
• Info File Name
• Initial File
• initialization section (PL/SQL packages)
• input parameters
• INSERT statement (SQL)
• Internet Protocol based Restriction
• IP addresses
  • Domain Name Resolution of
  • security based on
  • Web Listener
• IP-based restriction [2] [3]
• ISINDEX [2]
• ISMAP attribute

  J

• joins
  • natural
  • outer

  K

  L

• labels, PL/SQL
• languages
  • associating with character sets
  • default
• links
  • to other documents
  • to other sections
• list tags
  • definition
  • nested
  • ordered
  • types of
  • unordered
• Log File Directory [2]
• log files
  • default
  • Web Agent Service
• loops (PL/SQL)
  • exiting nested
  • FOR
  • WHILE

  M

• mailto
• Max Connect Count
• MIME (Multimedia Internet Mail Extension) types
  • default
  • defining
  • further information
• Modify Service button
• multimedia data
  • file types of
  • in Oracle7 database
  • MIME types

  N

• naming conventions
  • PL/SQL
    • tables
  • SQL
• natural joins
• network communications
  • port selection
• NLS Language
• NOT NULL constraint (SQL) [2]
  • PL/SQL use of
• NULL statement (PL/SQL)
• nulls
  • as Boolean values
  • database contains
  • differentiated from NULL statement
  • outer joins generate
  • prohibiting [2]
  • SQL handling of
  • UPDATE statement (SQL) generates
  • variables initialized to (PL/SQL)

  O

• objects, aliases for database objects [2]
  • ownership of database [2]
• Oracle Web Agent, description of
• Oracle7 Server [2]
  • stores multimedia data
• ORACLE_HOME
  • default log file directory in
  • Web Agent Service uses
• ORACLE_SID
• outer joins
• output parameters
• OWA Database User
• OWA Log Directory, defines Web Agent error log
• OWA Service
• OWA Service Name, defines Web Agent error log
• OWA User Passord
• OWA Utilities package, description of
• owa.cfg
  • sample with parameters
  • Web Agent uses
• owa.err [2]
• OWA_DEFAULT_SERVICE [2]
  • deleted services and
• OWA_UTIL Package
  • definition of
• owa, calling procedures with
• OWAINS.SQL sql script, using to install Developer's Toolkit

  P

• packages
  • bodies
  • creating
  • specification
• parameters
  • actual (PL/SQL)
  • formal (PL/SQL)
  • in PL/SQL
  • in PL/SQL packages
  • log file
  • modes of (PL/SQL)
  • network
  • Web Agent Service
• parent keys [2]
• passwords
  • changing
  • database
  • Web Agent Service uses [2]
  • Web Listener
• PID (Process Identifier), Web Listener
• PL/SQL
  • blocks
  • declarations
  • DECLARE section
  • EXCEPTION section
  • EXECUTABLE section
  • flow control in
  • general discussion of
  • generating dynamically
  • GOTO restrictions
  • overloading subprograms
  • scope of objects and subprograms
  • sections of
  • subprograms
  • user-defined datatypes in
• Port Number [2]
• ports
  • changing to copy Web Listeners
  • reserved
  • selecting
  • Web Listeners associated with [2]
  • Web Listeners identified by
• pragmas (PL/SQL)
• predicates
  • in IF statements (PL/SQL)
  • in SQL [2]
• primary keys
  • enforcing
• private synonyms [2]
• privileges
  • object
  • required to create triggers
  • stored procedures require
  • stored procedures use
  • system
• procedures
• procedures and functions, getting started
• procedures
  • declaring
  • grouped into packages
  • storing in database
• profiles [2]
• public synonyms [2]
  • for WebServer paths

  Q

• queries (SQL)
  • multiple tables used in
  • stored in cursors (PL/SQL)
  • within other queries (subqueries)
• query string
• QUERY_STRING environmental variable, passing parameters with

  R

• RAISE statement (PL/SQL) [2]
• range variables [2]
• RDBMS [2]
• realms
  • assigning
  • defined
• records
  • alternate name for database rows
  • PL/SQL datatype
• ref cursors (PL/SQL) [2]
• referenced keys
• referential integrity
• relational databases [2]
• reload
• REQUEST_METHOD environmental variable, passing parameters with
• restriction schemes
• RETURN statement (PL/SQL)
• return values
  • cursor (PL/SQL packages)
  • functions (PL/SQL)
• roles [2]
• rows [2]
  • of database tables

  S

• schemas [2]
• scope
  • of PL/SQL objects and subprograms
  • PL/SQL packages and
• SCRIPT_NAME variable, how Web agent uses
• scripts
• security
  • types of
  • Web Listener [2]
    • assignments
• SELECT statement (SQL) [2]
• servers, database [2]
  • web
    • Oracle
• service _name.err, Web Agent error log
• services
  • SQL*Net V2
  • Web Agent
• shutdown mode (database)
• shutdown, Web Listener
• SQL
• SQL*Net
  • V2 service specfication
• SQL, building applications using
• SQLCODE
• SQL, dynamic
• SQLERRM
• SQL
  • predicates
  • standards
  • Three-Valued Logic (TRUE, FALSE, NULL) in
• STANDARD package (PL/SQL)
• Start button
• startup mode (database)
• startup, Web Listener
• Stop button
• stored procedures
  • invoking in URL
• Structured Query Language
• Submit New Service button
• subprograms (PL/SQL)
  • declaring
  • error handling and
  • GOTO restrictions
  • overloading
  • parameters of
  • resolving ambiguous references
  • scope and visibility of
• subqueries (SQL)
• subtypes (PL/SQL) [2]
  • using to create PL/SQL records
  • using to create PL/SQL tables
• synonyms, for database objects

  T

• Table attributes
  • Align
  • Border
  • Colspan
  • Colspec
  • Nowrap
  • Rowspan
  • Valign
• tables, database [2] [3]
  • aliases for [2] [3]
  • creating
  • stored in cursors (PL/SQL)
• HTML
• in HTML
• ownership of
• passing as parameters in PL/SQL
• PL/SQL datatype
• PL/SQL