J

J date format element, SQL 2-46

Japanese version of LSM for Windows NT, LEG 2-18

Java, GTK 4-13

calling methods through call specifications, ADG 10-3

compatibility, MIG 9-9

generating wrapper classes with JPublisher, ADG 1-33

in the RDBMS, ADG 1-29

installing CartridgeServices.jar, MIG 8-5

installing ODCI.jar, MIG 8-5

JDBC drivers, GTK 3-17

loading into the database, ADG 10-4

Oracle JDBC and Oracle objects, ADO 3-12

Oracle SQLJ and Oracle objects, ADO 3-12

overview of JDBC, ADG 1-26

overview of SQLJ, ADG 1-30

removing incompatibilities for downgrading, MIG 13-34

SQLJ translator, GTK 3-18

triggers, SCN 81, SCN 88

upgrading, MIG 7-27

vs PL/SQL, ADG 1-39

with Oracle objects, ADO 3-12

Java Byte Code Obfuscation, OAS 3-4

Java class schema object

creating, SQL 7-312, SQL 7-313

dropping, SQL 7-483

resolving, SQL 7-45, SQL 7-312

JAVA clause

of CREATE TYPE, SQL 7-442

of CREATE TYPE BODY, SQL 7-450

Java clients, NLS and, OID 2-27

Java Database Connectivity

JDBC, OAS 3-2

Java DataBase Connectivity (JDBC) Drivers

see JDBC

Java DBAccess Interface layer, described, NET 3-13

Java Demo, DCI A-13

Java Demo Script, DCI A-13

Java development tools/utilities

JDeveloper, GTK 3-20

JPublisher, GTK 3-20

loadjava and dropjava, GTK 3-21

Java initialization parameters

JAVA_MAX_SESSIONSPACE_SIZE, SRF 1-48

JAVA_SOFT_SESSIONSPACE_LIMIT, SRF 1-49

Java Message Service, GTK 2-5

Java Messaging Service, SCN 68, SCN 78

Java method

mapping to an object type, SQL 7-442

Java methods

calling from Pro*COBOL, PCO 6-21

Java Native Interface, OID 2-33

Java NS, described, NET 3-14

Java RepAPI, REP A-5, REP C-1

administering, REP C-16

architecture, REP C-3

before configuring on server, REP C-7

callout classes, REP C-5

client engine, REP C-5

concepts, REP C-3

configuring the server for, REP C-1

CORBA, REP C-3

defined, REP C-2

deployment templates

packaging, REP C-14

initialization parameters, REP C-7

Java object, REP C-4

listener configuration, REP C-8

Oracle Client Replication Tool, REP C-16

preconfiguration tasks, REP C-7

sample program, REP C-17

examples, REP C-20

installing, REP C-17

using, REP C-17

server component, REP C-4

server object

loading, REP C-9

publishing, REP C-9

verify publication of, REP C-12

service URL, REP C-4

Java resource schema object

creating, SQL 7-312, SQL 7-313

dropping, SQL 7-483

Java runtime environment, NLS 6-2

Java schema object

name resolution of, SQL 7-314

Java scripts, SRF 5-7

Java Server Pages

translating to PSP, ADG 12-3

Java Sockets, described, NET 3-14

Java source schema object

compiling, SQL 7-45, SQL 7-312

creating, SQL 7-312, SQL 7-313

dropping, SQL 7-483

Java stored procedures, NLS 6-15, PCO A-2

Java Virtual Machine, NLS 6-14

Java VM, GTK 2-5, GTK 3-16

development models

CORBA, GTK 3-18

EJBs, GTK 3-18

Java stored procedures, GTK 3-18

JServer Accelerator, GTK 3-18

Java, See JDBC

JAVA_MAX_SESSIONSPACE_SIZE initialization parameter, SRF 1-48

JAVA_POOL_SIZE initialization parameter, REP 7-4, SRF 1-48

JAVA_SOFT_SESSIONSPACE_LIMIT initialization parameter, SRF 1-49

JavaASO, GTK 2-8

JavaNet, described, NET 3-14

Javascript

translating to PSP, ADG 12-3

java.sql.ResultSet, NLS 6-3

JavaTTC, described, NET 3-13

javax.jms.BytesMessage, ADQ B-20

javax.jms.Connection, ADQ B-22

javax.jms.ConnectionFactory, ADQ B-23

javax.jms.ConnectionMetaData, ADQ B-24

javax.jms.DeliveryMode, ADQ B-25

javax.jms.Destination, ADQ B-26

javax.jms.InvalidDestinationException, ADQ B-50

javax.jms.InvalidSelectorException, ADQ B-51

javax.jms.JMSException, ADQ B-52

javax.jms.MapMessage, ADQ B-27

javax.jms.MesageNotWriteableException, ADQ B-56

javax.jms.Message, ADQ B-28

javax.jms.MessageConsumer, ADQ B-29

javax.jms.MessageEOFException, ADQ B-53

javax.jms.MessageFormatException, ADQ B-54

javax.jms.MessageListener, ADQ B-30

javax.jms.MessageNotReadableException, ADQ B-55

javax.jms.MessageProducer, ADQ B-31

javax.jms.ObjectMessage, ADQ B-32

javax.jms.Queue, ADQ B-33

javax.jms.QueueBrowser, ADQ B-34

javax.jms.QueueConnection, ADQ B-35

javax.jms.QueueConnectionFactory, ADQ B-36

javax.jms.QueueReceiver, ADQ B-37

javax.jms.QueueSender, ADQ B-38

javax.jms.QueueSession, ADQ B-39

javax.jms.Session, ADQ B-40

javax.jms.StreamMessage, ADQ B-41

javax.jms.TextMessage, ADQ B-43

javax.jms.Topic, ADQ B-44

javax.jms.TopicConnection, ADQ B-45

javax.jms.TopicSession, ADQ B-48

javax.jms.TopicSubscriber, ADQ B-49

JDBC, GTK 4-13

authentication not supported, OAS 3-3

available LOB methods/properties, ADL 3-3

BFILE class

BFILE-buffering, ADL 3-43

BLOB and CLOB classes

calling DBMS_LOB package, ADL 3-37

changing internal LOBs with Java using objects oracle.sql.BLOB/CLOB, ADL 3-37

class library, NLS 6-5

configuration parameters, OAS 3-5

directory naming, NET 3-15

drivers, NET 3-11, NLS 6-2

encapsulating locators

implementation of Oracle Advanced Security, OAS 3-2

inserting a row with empty LOB locator into table, ADL 6-8

Java Database Connectivity, OAS 3-2

Java DBAccess Interface, NET 3-13

Java NS, NET 3-14

Java Sockets, NET 3-14

JavaNet, NET 3-14

methods/properties for BLOB-buffering, ADL 3-40

methods/properties for CLOB-buffering, ADL 3-41

modifying BLOB values, ADL 3-39

modifying CLOB values, ADL 3-40

OCI, NET 3-11

OCI driver

NLS considerations, NLS 6-6

Oracle Advanced Security features, OAS 3-3

Oracle extensions, OAS 3-2

Oracle O3LOGON, OAS 3-3

OracleBlob, OracleClob do not work in 8.1.x, ADL 3-43

reading internal LOBs and external LOBs (BFILEs) with Java, ADL 3-37

reading/examining BLOB values, ADL 3-39

reading/examining CLOB values, ADL 3-41

reading/examining external LOB (BFILE) values, ADL 3-42

referencing LOBs, ADL 3-37

See Oracle JDBC, ADG 1-26

See Oracle JDBC

Server driver, NLS 6-7

syntax references, ADL 3-38

TCP/IP Protocol, NET 3-14

Thin, NET 3-11

Thin driver

NLS considerations, NLS 6-7

thin driver features, OAS 3-3

using OracleResultSet to reference LOBs, ADL 3-38

using OUT parameter from OraclePreparedStatement to reference LOBs, ADL 3-38

JDBC drivers

and NLS, NLS 6-4

JDeveloper, GTK 2-5, GTK 3-20

JMS Application Sample, ADQ 12-1

JMS Classes, ADQ B-2

JMS Error Messages, ADQ D-1

JMS Examples Payload, ADQ 12-31

JMS Exceptions, ADQ B-2

JMS Extension, ADQ 3-10

JMS Interfaces, ADQ B-2

JMS queue cannot be created in multi-consumer enabled queue tables - error, ADQ D-8

JMS queue cannot be multi-conumer enabled - error, ADQ D-6

JMS queues cannot contain payload of type RAW - error, ADQ D-14

JMS topic must be created in multi-consumer enabled queue tables - error, ADQ D-7

JMSClasses, ADQ B-5

job interval, RAR 1-5

job processes, RAR 1-4

job queue, REP 2-20

job queue processes (SNPn), SCN 1-19, SCN 8-13

message propagation, SCN 76

job queues

altering jobs, SAD 8-11

broken jobs, SAD 8-12

DBMS_JOB package, SAD 8-3

executing jobs in, SAD 8-9

locks, SAD 8-9

removing jobs from, SAD 8-10

SNP processes, SAD 8-2

submitting jobs to, SAD 8-4 to SAD 8-8

terminating jobs, SAD 8-14

viewing information, SAD 8-14

JOB_QUEUE_INTERVAL initialization parameter, RAR 1-4, REP 2-23, REP 7-4, SRF 1-49

JOB_QUEUE_INTERVAL initialization parameter
, SAD 8-3

JOB_QUEUE_INTERVALS parameter, DWG 14-19

JOB_QUEUE_KEEP_CONNECTIONS initialization parameter: obsolete

JOB_QUEUE_PROCESSES, ADQ 2-7

JOB_QUEUE_PROCESSES initialization parameter, RAR 1-4, REP 2-23, REP 3-34, REP 7-4, SAD 8-3

JOB_QUEUE_PROCESSES parameter, DWG 14-19, SCN 76, SRF 1-50

of ALTER SYSTEM, SQL 7-111

jobs, SCN 8-2

altering, SAD 8-11

and instance affinity, PSA 5-17

broken, SAD 8-12

checking for scheduled links, REP B-6

choosing tasks for, PSG 7-22

creating for Oracle Parallel Server, PSG 7-19

database links and, SAD 8-8

environment, recording when submitted, SAD 8-5

executing, SAD 8-9

exporting, SAD 8-6

forcing to execute, SAD 8-13

importing, SAD 8-6

INTERNAL date function and, SAD 8-8

job definition, SAD 8-7

job number, SAD 8-7

ownership of, SAD 8-7

queues for

removing jobs from, SPR 11-23, RAR 8-38

removing from job queue, SAD 8-10

RMAN, RMN 1-9

monitoring performance, RMN 9-17

monitoring progress, RMN 9-14

running broken jobs, SAD 8-13

setting up rights for running, PSG 7-24

specifying information for, PSG 7-21

specifying parameters for OPSM tasks, PSG 7-23

submitting to job queue, SAD 8-4

terminating, SAD 8-14

trace files for job failures, SAD 8-9

troubleshooting, SAD 8-9

join compatibility, DWG 19-10

JOIN KEY clause

of ALTER DIMENSION, SQL 7-26

of CREATE DIMENSION, SQL 7-280

join views, ADG 2-21, SCN 10-16

definition, SAD 18-3

DELETE statements, ADG 2-24, SAD 18-8

key-preserved tables in, ADG 2-22, SAD 18-6

mergeable, ADG 2-22

modifying, ADG 2-23, SAD 18-5, SQL 7-466, SQL 7-541, SQL 7-618

rule for, SAD 18-7

UPDATE statements, ADG 2-24

updating, SAD 18-5

when modifiable, ADG 2-21

joins, DWG 8-11, PLS 7-41, SQL 5-22

anti-joins, STU 4-61

Cartesian products, STU 4-48

cluster, SCN 10-52, STU 4-36, STU 4-55

searches on, STU 4-38

conditions

defining, SQL 5-22

convert to subqueries, STU 4-74

cross, STU 4-48

defined, STU 4-47

distributed databases

managing statement transparency, DDS 2-33

encapsulated in views, SCN 1-23, SCN 10-14

equijoins, SQL 5-22, STU 4-47

execution plans and, STU 4-49

for simple subquery snapshots, REP 3-15

full partition-wise, DWG 5-12

hash joins, STU 4-53

index joins, STU 4-24

join order

execution plans, SCN 124, STU 4-5

selectivity of predicates, SCN 131, SCN 132, SCN 141, STU 4-33, STU 8-2, STU 8-17

nested loops, STU 4-50

cost-based optimization, STU 4-59

non-equijoins, STU 4-47

optimization of, STU 4-60

outer, SQL 5-23, STU 4-47

non-null values for nulls, STU 4-86

restrictions, SQL 5-23

parallel, and PQ_DISTRIBUTE hint, STU 7-26

partial partition-wise, DWG 5-17

partition-wise, DWG 5-12, SCN 11-5

examples of full, STU 5-20

examples of partial, STU 5-19

full, STU 5-20

restriction on, PC_ 6-18

sample table scan not supported, STU 4-21

select-project-join views, STU 4-76

self, SQL 5-23

semi-joins, STU 4-61

sort-merge, STU 4-51

cost-based optimization, STU 4-59

example, STU 4-43

star joins, DWG 16-3, STU 4-62

star queries, DWG 16-2, STU 4-62

views, SCN 1-23, SCN 10-16

without join conditions, SQL 5-23

JPEG images, adding with ldapadd, OID A-9

jpegPhoto attribute, OID 2-5, OID 7-26

JPublisher, ADG 1-35, GTK 3-20

building an empty LOB in, ADL 6-9

JQ locks, SAD 8-9

JScript

translating to PSP, ADG 12-3

JServer Accelerator, GTK 3-16

JServer. See Java VM

JSQL, GTK 4-13

Julian day, specifying, SQL 2-47

JVM, NLS 6-14

JVM. See Java VM

JVMU815.SQL script, MIG 7-27