Cover | Table of Contents | Colophon
[ Symbols ], [ A ], [ B ], [ C ], [ D ], [ E ], [ F ], [ G ], [ H ], [ I ], [ J ], [ K ], [ L ], [ M ], [ N ], [ O ], [ P ], [ Q ], [ R ], [ S ], [ T ], [ U ], [ V ], [ W ], [ X ]
Symbols[ Top ]
assertion, OWA_PATTERN package, 144
& special character, OWA_PATTERN package, 144
( ) special character, OWA_PATTERN package, 144
* quantifier, OWA_PATTERN package, 143
+ quantifier, OWA_PATTERN package, 143
. atom, OWA_PATTERN package, 143
<a>...</a> tag, HTML, 91
<b>...</b> tag, HTML, 89
<body>...</body> tag, HTML, 89
<br>...</br> tag, HTML, 90
<center>...</center> tag, HTML, 90
<font>...</font> tag, HTML, 89
<form>...</form> tag, HTML, 95-96
<head>...</head> tag, HTML, 89
<hn>...</hn> tag, HTML, 90
<hr>...</hr> tag, HTML, 90
<html>...</html> tag, HTML, 88
<i>...</i> tag, HTML, 90
<input> tag, HTML, 96-99
<li>...</li> tag, HTML, 91
<ol>...</ol> tag, HTML, 91
<option>...</option> tag, HTML, 96
<p>...</p> tag, HTML, 90
<pre>...</pre> tag, HTML, 90
<select>...</select> tag, HTML, 96, 99
<small>...</small> tag, HTML, 90
<sup>...</sup> tag, HTML, 90
<table>...</table> tag, HTML, 93
<textarea>...</textarea> tag, HTML, 96, 100
<th>...</th> tag, HTML, 93
<title>...</title> tag, HTML, 89
<tr>...</tr> tag, HTML, 93
<tt>...</tt> tag, HTML, 90
<ul>...</ul> tag, HTML, 91
? quantifier, OWA_PATTERN package, 143
\b atom, OWA_PATTERN package, 143
\c atom, OWA_PATTERN package, 143
\D atom, OWA_PATTERN package, 143
\d atom, OWA_PATTERN package, 143
\n atom, OWA_PATTERN package, 143
\nnn atom, OWA_PATTERN package, 143
\S atom, OWA_PATTERN package, 143
\s atom, OWA_PATTERN package, 143
\t atom, OWA_PATTERN package, 143
\W atom, OWA_PATTERN package, 143
\w atom, OWA_PATTERN package, 143
\xnn atom, OWA_PATTERN package, 143
^ assertion, OWA_PATTERN package, 144
{n,} quantifier, OWA_PATTERN package, 143
{n,m} quantifier, OWA_PATTERN, 143
A[ Top ]
abstract data types (ADTs), 124
accounts payable, 2
accounts receivable, 2
Active Server Pages, 6
actual parameters, 107
ADD2MULTI procedure, OWA_TEXT package, 140
Adobe PDF, 19
ADTs (abstract data types), 124
Advanced Networking Option (ANO), 48
Advanced Queuing (AQ), 10, 20-23
AIFF format, 19
Alpha, 7
AltaVista, 4
AMATCH function, OWA_PATTERN package, 145, 147
ANCHOR function, HTF package, 138
ANCHOR procedure, HTP package, 134
anchored declarations, 114
ANO (Advanced Networking Option), 48
answer_survey procedure, EMP_SURVEY package, 187-189
APIs (application programming interfaces), 18, 124
applets, Java, 6
application development, 1-3, 6-7, 14
application integration and electronic data interchange, 1-3, 7-8
application programming interfaces (APIs), 18, 124
application servers, 6
AQ (Advanced Queuing), 10, 20-23
AQ Lite, 18
assertions, OWA_PATTERN package, 144
asynchronous mode, replication, 17
attributes, HTML, 85
AUF format, 19
AVI format, 19, 27
B[ Top ]
back references (backrefs), OWA_PATTERN package, 144
BEGIN command, PL/SQL, 104
blocks, 103-104
body, HTML form tag, 88
body, PL/SQL, 103
bottom-up design, PL/SQL, 103
broken links, 5
browser-specific extensions, HTML, 101
C[ Top ]
C, 6, 16, 103
C++, 6, 103
CA (certification authority), 48
calendar wizard, WebDB, 57
cartridges, 6, 76-77
CASE statements, 104, 116
CAST Workbench, 130
categories, WebDB dashboard, 63-64
certification authority (CA), 48
CGI (common gateway interface), 6, 72-76
CHANGE function, OWA_PATTERN package, 145, 148-150
chart wizard, WebDB, 58
CHECKSUM procedure, OWA_OPT_LOCK package, 158, 161-163
COBOL, 1, 6, 20, 103
colors library, WebDB, 59
COM, 8
comment, HTML form tag, 88
common gateway interface (CGI), 6, 72-76
complete refresh, 17
connecting databases to Web, 23
content delivery model, 33-37
HTTP listener, 35-36
PL/SQL gateways, 36-37
content management, 1-6, 14
CORBA, 8, 15
create_msg_form procedure, FORUM package, 210-211
create_user_form procedure, FORUM_USERS package, 204-205
current_forum_list procedure, FORUM package, 208-209
cursors
declaring, 118-119
implicit, 121
processing, 119-121
D[ Top ]
DAD (see Database Access Descriptor)
dashboards, WebDB, 62
data warehousing, 1-2
Database Access Descriptor (DAD), 31, 34-36, 66-67
Database Access Descriptor Name parameter, DAD, 66
database administration, 14
database integration, 37-41
PL/SQL example, 38-41
PL/SQL toolkit, 37-38
database security, 42-49
objects, 42-43
privileges, 43-45
roles, 45-47
users, 42
datatype indicators, HTP package, 135
datatype parameter, PL/SQL, 107, 113-114
DBDOM package, 227
DBXML package, 226-227
DBXSL package, 227
declaration section, PL/SQL, 103
DECLARE keyword, PL/SQL, 103
default (home) page parameter, DAD, 67
default MIME type parameter, server settings, 69
default values, PL/SQL, 107, 114
dequeuing, 21
Developer/2000 applications, 16
developing web applications, 23
digital certificates, 48
disaster planning, 8
display_survey_list procedure, EMP_SURVEY package, 186-187
DLL (Dynamic Link Library), 18
DNS (Domain Name Server), 29
Document Access Path parameter, DAD, 67
Document Access Procedure parameter, DAD, 67
Document Table parameter, DAD, 67
document type definition (DTD), 219-221
Domain Name Server (DNS), 29
DOS, 4
DTD (document type definition), 219-221
Dynamic Link Library (DLL), 18
dynamic page wizard, WebDB, 58
dynamic resources, 6, 27-28
E[ Top ]
e-commerce (electronic commerce), 1-2
EJB (Enterprise Java Beans), 15
email, 2
EMP_SURVEY package, 185-193
answer_survey procedure, 187-189
display_survey_list procedure, 186-187
process_survey procedure, 189-190
view_results procedure, 190-192
encryption, 48
END command, PL/SQL, 104
END LOOP command, PL/SQL, 117
enqueuing, 21
Enterprise Java Beans (EJB), 15
enterprise resource planning (ERP)
systems, 1-2
EnterpriseSync Lite (ESL), 17-18
ERP (enterprise resource planning), 1-2
ESL (EnterpriseSync Lite), 17-18
Eudora, 10, 17
executable section, PL/SQL, 103
EXECUTE permission, PL/SQL, 111
F[ Top ]
fast refresh, 17
file attributes, 4
file extensions, 70
filesystems, 4
file, WebDB dashboard, 62
firewalls, 48
flags, OWA_PATTERN package, 144
folderlink, WebDB dashboard, 62
folders, WebDB dashboard, 63
fonts library, WebDB, 59
form wizard, WebDB, 58
formal procedures, PL/SQL, 107
forms HTML, 40
FORTRAN, 6
FORUM package, 206-212
create_msg_form procedure, 210-211
current_forum_list procedure, 208-209
print_thread_links procedure, 207-208
save_message procedure, 211-212
view_message procedure, 209-210
FORUM_USERS package, 199-206
create_user_form procedure, 204-205
get_current_user function, 204
login procedure, 202-203
save_user_info procedure, 204-205
frame driver wizard, WebDB, 58
FROG (Funky Resource for Oracle Gorillas), 130
FrontPage, 19
FTP, 10
function wizard, WebDB, 55
G[ Top ]
g flag, OWA_PATTERN package, 144
gateways, PL/SQL, 36-37
GENERAL_FORM package, 197-199
geographic information system (GIS), 19
GET function, OWA_COOKIE package, 153, 155-156
GET_ALL procedure, OWA_COOKIE package, 153, 156
get_attribute function, XML_INVOICE_PKG, 222-223
GET_CLIENT_HOSTNAME procedure, OWA_SEC package, 179
GET_CLIENT_IP procedure, OWA_SEC package, 38, 179
get_current_user function, FORUM_USERS package, 204
GET_PASSWORD procedure, OWA_SEC package, 179
GET_PAT function, OWA_PATTERN package, 145
GET_ROWID procedure, OWA_OPT_LOCK package, 158, 160-161
GET_USER_ID procedure, OWA_SEC package, 38, 179
GIF format, 6, 19, 27
GIS (geographic information system), 19
GRANT EXECUTE command, 111-112
groups, WebDB, 64
H[ Top ]
hackers, 2
handlers, 104
hardware platforms, 6
head, HTML form tag, 88
HEADCLOSE procedure, HTP package, 135
header section, PL/SQL, 103
HEADOPEN procedure, HTP package, 135
hierarchy wizard, WebDB, 58
HTF package, 37
ANCHOR function, 138
PRINT function, 138
HTML, 2, 6, 9, 11-12
attributes, 85
browser-specific extensions, 101
forms, 40
learning, 84
programming in, 83-86
reasons for using, 24-25
static resources, 27
syntax, 84-86
tags, 84-85
I[ Top ]
I flag, OWA_PATTERN package, 144
IF-THEN conditional statements,
PL/SQL, 116
IF-THEN-ELSE conditional statements, PL/SQL, 116
i
FS (Internet File System), 9-11, 227-228
imagemap, WebDB dashboard, 62
images, 2
images library, WebDB, 60
IMAP4, 10
index wizard, WebDB, 55
index-by table
adding elements to, 123
creating, 122-123
retrieving elements from, 123-124
information hiding, 128-129
inheritance, 42
int_arr data structure, OWA_TEXT
package, 139
Intel, 6
internal applications, 2
Internet File System (
i
FS), 9-11, 227-228
Internet storefronts, 2
Internet technology, overview, 1-8
InternetLite, 9, 16-18
InternetLite server and API, 18
invoices, 2
J[ Top ]
Java, 9-10
applets, 6
dynamic resources, 28
Enterprise Java Beans (EJBs), 15
Java Access Classes (JACs), 16
Java stored procedures (JSPs), 15
JavaScripts library, 60
servlets, 6, 15-16
JDBC, 15-16, 65
JPEG format, 6, 19, 27
K[ Top ]
Keep Database Connection Open between Requests? parameter, DAD, 67
L[ Top ]
LAN (local area network), 2, 27
laptops, 2
learning HTML, 84
limitation, CGI interface, 75-76
links, 5
links library, WebDB, 60
Linux, 29
lists of values (LOV) library, WebDB, 60
location transparency, 46
logging level parameter, server settings, 69
LOOP command, PL/SQL, 117
M[ Top ]
master sites, 16
MATCH function, OWA_PATTERN
package, 145-146
Maximum Number of Worker Threads parameter, DAD, 67
menu wizard, WebDB, 58
metadata, 5
metainformation, 86
Microsoft
Access, 16-17
Excel, 4, 10, 19
FrontPage, 3, 6
Internet Explorer, 30
Outlook, 10, 17
PowerPoint, 19
Windows 95, 29
Windows 98, 29
Windows NT, 6, 29
Word, 19
MIME (Multipurpose Internet Mail Extensions), 32-33
MIME type, WebDB, 70
mobile applications, 2, 16
mode, PL/SQL, 107
MPEG format, 19, 27
multi_line data structure, OWA_TEXT package, 139
multimedia data, 2, 18-19
N[ Top ]
name value, PL/SQL, 113
named notation, PL/SQL, 108-110
Net8, 30, 48
Netscape Communicator, 30
NEW_MULTI procedure, OWA_TEXT package, 140
NEW_ROW_LIST procedure, OWA_TEXT package, 140
normal procedure calls, 41
O[ Top ]
OAS (see Oracle Application Server)
object privileges, 44-45
Object Request Brokers (ORB), 6
object wizards, WebDB, 55
objects, 42-43
OCA (Open Client Adapter), 16
OCI (Oracle Call Interface), 16
OEM (Oracle Enterprise Manager), 14
Open Client Adapter (OCA), 16
optimistic versus pessimistic locking, 157
Oracle Application Server (OAS), 9, 14
dynamic resources, creating, 78-82
web resources, returning, 72-78
Oracle Audio/Video Server, 19
Oracle Call Interface (OCI), 16
Oracle Connect String parameter, DAD, 67
Oracle Enterprise Manager (OEM), 14
Oracle Forms, 7, 17
Oracle interMedia, 9, 18-19
Oracle Lite, 16-17
Oracle Password parameter, DAD, 66
Oracle Procedure Builder, 130
Oracle Spatial cartridge, 18-19
Oracle User Name parameter, DAD, 66
Oracle8i, overview, 1, 8-10, 22-26
ORB (Object Request Broker), 6
order entry systems, 2
OS/2, 29
OWA_COOKIE package, 37
GET function, 153, 155-156
GET_ALL procedure, 153, 156
REMOVE procedure, 153, 155
SEND procedure, 153-155
OWA_IMAGE package, 37
OWA_OPT_LOCK package, 37, 156-163
CHECKSUM procedure, 158, 161-163
GET_ROWID procedure, 158, 160-161
STORE_VALUES procedure, 158-159
VERIFY_VALUES procedure, 158, 160
OWA_PATTERN package, 38, 143-147
OWA_SEC package, 38, 179
OWA_TEXT package, 38
ADD2MULTI, 140
int_arr data structure, 139
multi_line data structure, 139
NEW_MULTI procedure, 140
NEW_ROW_LIST procedure, 140
PRINT_MULTI procedure, 140
PRINT_ROW_LIST procedure, 140
row_list data structure, 139
STREAM2MULTI procedure, 140
vc_arr data structure, 139
OWA_UTIL package, 38, 153-154, 163-178
BIND_VARIABLES procedure, 163, 172, 174-175
CALENDARPRINT procedure, 163, 172, 177-178
CELLSPRINT procedure, 163, 172, 175-176
CHOOSE_DATE procedure, 163, 167-168
DATETYPE datatype, 163, 167-168
debugging, 164
GET_CGI_ENV procedure, 163, 165-166
GET_OWA_SERVICE_PATH function, 163, 165, 167
GET_PROCEDURE function, 163, 165
HTML and HTTP, 168-169
HTTP_HEADER_CLOSE procedure, 163, 168, 171
IP_ADDRESS datatype, 164, 166-167
LISTPRINT procedure, 164, 172, 176-177
MIME_HEADER procedure, 164, 168-170
PRINT_CGI_ENV procedure, 164, 166
querying the environment, 165-166
REDIRECT_URL procedure, 164, 169-171
representing dates, 167
SHOWPAGE procedure, 164-165
SHOWSOURCE procedure, 164
SIGNATURE procedure, 164, 169
STATUS_LINE procedure, 164, 169-170
TABLEPRINT function, 164, 171-174
TODATE function, 164, 167-168
WHO_CALLED_ME procedure, 164-165
P[ Top ]
package wizard, WebDB, 56
PalmPilots, 2
parameter arrays, 40
parameter name, PL/SQL, 107
parameter passing, PL/SQL, 80
Pascal, 102
PDA (Personal Data Assistant), 2
Perl, 6-7, 28
Personal Data Assistant (PDA), 2
perspectives, WebDB, 64
physical directories, WebDB, 69
PL/Formatter, 130-132
PL/SQL, 7, 9, 13, 20
calling procedures and functions, 108-110
comments, 112-115
conditionals, 116
cursors, 118-121
declaration section, 103
dynamic resources, 28
example, 38-41
exception section, 104
executable section, 103
functions, 105-106
gateways, 36-37, 40
header section, 103
index-by tables (arrays), 122-124
information hiding, 128-129
largest string size, 138-139
loops, 116-118
overloading, 110-111
packages, 124-130
parameters, 107-108
permissions, 111-112
PL/Formatter, 131-132
procedures, 104-105
programming constructs, 112-124
reasons to use, 25-26
structured programming in, 102-112
TOAD, 130-131
toolkit, 34, 37
tools, 130-132
variable persistence throughout a session, 129-130
WebAlchemy, 136-137
PL/SQL call, WebDB dashboard, 62
PL/SQL toolkit
HTF package, 137-138
HTP package, 134-136
OWA_COOKIE package, 152-156
OWA_IMAGE package, 37
OWA_LOCK, 156-163
OWA_PATTERN package, 142-159
OWA_SEC package, 179
OWA_TEXT package, 138-142
OWA_UTIL package, 163-178
PLEdit, 130
PLSXML utilities and demos, 226-227
polymorphism, 42
POP3, 10
port 21, TCP/IP, 30
port 25, TCP/IP, 80
port 80, TCP/IP, 30
portable devices, 2
positional notation, 108-109
PowerBuilder, 16
PRINT function, HTF package, 138
PRINT procedure, HTP package, 134
print_invoice procedure, XML_INVOICE_PKG, 225-226
print_items procedure, XML_INVOICE_PKG, 222, 224-225
PRINT_MULTI procedure, OWA_TEXT package, 140
PRINT_ROW_LIST procedure, OWA_TEXT package, 140
print_thread_links procedure, FORUM package, 207-208
print_xml_tag procedure, XML_INVOICE_PKG, 222-224
privileges, 43-45, 53, 65
Pro*COBOL, 20
Procedural Language (PL), 102
procedure wizard, WebDB, 56
process_survey procedure, EMP_SURVEY package, 189-190
programming in HTML, 83-86
Q[ Top ]
Qualcomm Eudora, 10, 17
Query by Example (QBE) forms, 58
query strings, 40
Quicktime format, 19
R[ Top ]
real arrays versus index-by tables, 122
RealNetworks, 19
reasons for using HTML, 24-25
record locking, OWA_OPT_LOCK package, 156-163
refresh options, 17
RegExp (regular expressions), OWA_PATTERN package, 142-143
relational database management systems (RDBMSs), 8
REMOVE procedure, OWA_COOKIE package, 153, 155
REPAPI (Replication API), 17
replication modes, ESL, 17
report wizard, WebDB, 58
resources, 27-28
result sets, 118
RETURN command, PL/SQL, 106
RevealNet, 131-132
roles, 45-47, 53
root privileges, 29
row_list data structure, OWA_TEXT package, 139
S[ Top ]
sales force automation, 2
save_message procedure, FORUM
package, 211-212
search engines, 4-5
searchable attributes, 5
Secure Socket Layer (SSL), 48
security, 42-49, 53
anonymous survey application, 192
discussion forum package, 192
OWA_SEC package, 38, 179
security (
continued
)
PL/SQL cartridge, 81-82
system privileges, 43-44
WebDB, 53
SEND procedure, OWA_COOKIE package, 153-155
sequence wizard, WebDB, 56
Server Port parameter, server settings, 69
server-to-client communications, 28
analogy between Web and phone system, 33
communication ports, 29
HTTP (hypertext transfer protocol), 29-30
resource MIME type, 32-33
TCP/IP networks, 28-29
URL (Uniform Resource Locator), 31-32
web browsers, 30-31
servlets, Java, 6, 15-16
SET_AUTHORIZATION procedure, OWA_SEC package, 179
SET_PROTECTION_REALM procedure, OWA_SEC package, 179
SGML (Standardized General Markup Language), 214
shared component libraries, 59-60
signatures, 110
site administrators, 64
SMB, 10
SMTP, 10
snapshot sites, 16
software development kit (SDK), 60
software port, 29
Sparc, 7
spreadsheets, 2, 4
SQL Navigator, 130
SQL Programmer, 130
SQL Station, 130
SQL*Net, 30, 48
SQL*Object Builder, 130
SQL/Expediter, 130
SQLJ, 15
SSL (Secure Socket Layer), 48
state versus stateless, 30
static resources, 27-28, 73-74
stdout, 14
STORE_VALUES procedure, OWA_OPT_LOCK package, 158-159
storyboards, creating, 181-182
STREAM2MULTI procedure, OWA_TEXT package, 140
streaming servers, 19
Sun Ultraservers, 6
SWITCH statements, 116
Symantec Visual Page, 19
synchronous mode, replication, 17
synonym wizard, WebDB, 56
synonyms, 46
syntax HTML, 84-86
system privileges, 43-44
T[ Top ]
table data, 2
table wizard, WebDB, 56
tags, HTML
anchor tags, 87, 91
content flow tags, 87, 90-91
form tags, 88, 95-101
list tags, 87, 91-92
structural tags, 87-88
table tags, 87, 93-94
text formatting tags, 87, 89-90
text cartridge, 18-19
text item, WebDB dashboard, 62
TIFF format, 19
TOAD, PL/SQL, 130-131
top-down design, 104
traditional filesystems, 8
traditional relational data, 2
trigger wizard, WebDB, 56
TXT format, 27
type wizard, WebDB, 56
U[ Top ]
UI templates library, 60
Unix, 6, 29
URLs, 5-6
path, 31
port, 31
protocol, 31
query string, 32
resolution, 34
resource name, 31
server, 31
WebDB dashboard, 62
users, 42, 53
V[ Top ]
values, assigning in PL/SQL, 114-115
variables, declaring in PL/SQL, 113-114
vc_arr data structure, OWA_TEXT package, 139
VERIFY_VALUES procedure, OWA_OPT_LOCK package, 158, 160
Video Information Retrieval (VIR) cartridge, 18-19
videos, 2, 19
view wizard, WebDB, 57
view_message procedure, FORUM package, 209-210
view_results procedure, EMP_SURVEY package, 190-192
VIR (Video Information Retrieval cartridge), 18-19
virtual directories, 70, 73-74
virtual machine, 30
Virtual Reality Modeling Language
(VRML), 28
Visual Basic, 16
VMS, 6
W[ Top ]
WAN (wide area network), 3, 27
WAV format, 19, 27
web applications, designing
anonymous surveys example, 183-193
data models, creating, 182
development options, evaluating, 180-181
discussion forum example, 193-213
PL/SQL packages, using, 183
storyboards, creating, 181-182
web management, content driven, 14
Web Request Broker (WRB)
cartridges, 76-77
WRB dispatcher, 77-78
WRB Executable Engines (WRBX), 77
web sites, tracking changes, 5-6
WebAlchemy, 136-137
WebDB, 9, 14
application development, 54-61
custom components, building, 60
database objects, building, 55
shared components, building, 58-60
user interface components, building, 57-58
wizards, 56-57
content-driven web site management, 61-65
access to content, controlling, 64-65
managing content, 63-64
user-uploaded content, 62-63
database access descriptor (DAD), 66-68
configuration file, 68
parameters, 66-68
database administration, 51-54
browsing database objects, 52
monitoring performance, 53-54
security, 53
HTTP listener, 68-71
configuration file, 70-71
MIME type mappings, 70
server settings, 69
virtual directory mappings, 69-70
introduction, 50-51
PL/SQL gateway, 66
wizards, WebDB, 14, 54-57
Word files, 10
WordPerfect, 19
World Wide Web, origins, 1
WRB dispatcher, 77-78
WRB Executable Engines (WRBXs), 77
X[ Top ]
XML (Extensible Markup Language), 2, 9, 12-13, 214-228
document type definition (DTD), 219-221
generating invoices from Oracle, 221-226
i FS (Internet File System), 227-228
motivations for using, 216-217
parsers, 221
PLSXML utilities and demos, 226-227
syntax, 217-219
XML_INVOICE_PKG, 221-226
get_attribute function, 222-223
print_invoice procedure, 225-226
print_items procedure, 222, 224-225
print_xml_tag procedure, 222-224