---

J

J date format element, SQL 2-41

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

Java, GTK 3-13, NET 2-16, NET 2-18

compatibility, MIG 8-9

in the RDBMS, ADG 1 - 29

JDBC drivers, GTK 2-17

Oracle JDBC and Oracle objects, ADG 19 - 19

Oracle SQLJ and Oracle objects, ADG 19 - 19

removing incompatibilities for downgrading, MIG 12-26

SQLJ translator, GTK 2-18

triggers, SCN 20-1, SCN 20-7

upgrading

drop Java objects, MIG 7-36

export Java objects, MIG 7-3

import Java objects, MIG 7-36

with Oracle objects, ADG 19 - 19

Java class schema object

creating, SQL 7-293, SQL 7-294

dropping, SQL 7-457

resolving, SQL 7-43, SQL 7-293

JAVA clause

of CREATE TYPE, SQL 7-416

of CREATE TYPE BODY, SQL 7-424

Java DataBase Connectivity (JDBC) Drivers

see JDBC

Java DBAccess Interface layer, described, NET 2-18

Java development tools/utilities

JDeveloper, GTK 2-21

JPublisher, GTK 2-20

loadjava and dropjava, GTK 2-21

Java method

mapping to an object type, SQL 7-416

Java methods

calling from Pro*COBOL, PCO 6-21

Java NS, described, NET 2-18

Java option

configuring, NET 7-50

connections, NET 7-50

dispatcher configuration, NET 7-63

listener configuration, NET 7-54

listener configuration, NET 7-56

Java resource schema object

creating, SQL 7-293, SQL 7-294

dropping, SQL 7-457

Java schema object

name resolution of, SQL 7-295

Java Sockets, described, NET 2-18

Java source schema object

compiling, SQL 7-43, SQL 7-293

creating, SQL 7-293

dropping, SQL 7-457

java source schema object

creating, SQL 7-294

Java Stored Procedures

configuring, NET 7-51

described, NET 7-50

Java stored procedures, PCO A-2

Java VM, GTK 2-16

development models

CORBA, GTK 2-18

EJBs, GTK 2-18

Java stored procedures, GTK 2-18

JServer Accelerator, GTK 2-18

Java VM, described, NET 7-51

JAVA_POOL_SIZE parameter, SRF 1-52

JavaNet, described, NET 2-18

JavaTTC, NET 2-18

JavaTTC, described, NET 2-18

JDBC, GTK 3-13

drivers, NET 2-16

Java DBAccess Interface, NET 2-18

Java NS, NET 2-18

Java Sockets, NET 2-18

JavaNet, NET 2-18

JavaTTC, NET 2-18

OCI, NET 2-16

TCP/IP Protocol, NET 2-18

Thin, NET 2-16

JDBC See Oracle JDBC

JDeveloper, GTK 2-21

Job, SAD 8-3

job, SBR 4-8

job interval, RAR 1-3

Job Processes, RAR 1-3

job queue enqueue, SRF B-2

job queue process, REP 2-11

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

message propagation, SCN 19-10

job queues, REP 2-4, SAD 8-2, SAD 8-3

executing jobs in, SAD 8-9

locks, SAD 8-9

privileges for using, SAD 8-4

removing jobs from, SAD 8-11

scheduling jobs, SAD 8-3

viewing, SAD 8-15

JOB_QUEUE_INTERVAL initialization parameters, REP 7-7

JOB_QUEUE_INTERVAL parameter, SRF 1-52

JOB_QUEUE_PROCESSES initialization parameters, REP 7-7

JOB_QUEUE_PROCESSES parameter, SCN 19-10, SRF 1-53

of ALTER SYSTEM, SQL 7-103

jobs, SCN 8-2

altering, SAD 8-11

and instance affinity, SPS 4-9

breaking, REP 7-16

broken, SAD 8-12

checking for scheduled links, REP 7-33

choosing tasks for, PSC 6-35

creating for Oracle Parallel Server, PSC 6-31

database links and, SAD 8-9

diagnosing problems with, REP 7-16

enabling, REP 7-16

executing, SAD 8-9

exporting, SAD 8-7

forcing to execute, SAD 8-14

importing, SAD 8-7

INTERNAL date function and, SAD 8-8

job definition, SAD 8-7

job number, SAD 8-7

killing, SAD 8-14

local

displaying, REP 7-14

editing properties of, REP 7-15

managing, SAD 8-3

manually executing, REP 7-15

marking broken jobs, SAD 8-13

ownership of, SAD 8-7

queues for

removing jobs from, SPR 10 - 19, RAR 8-41 to RAR 8-42

removing from job queue, SAD 8-11

running broken jobs, SAD 8-13

scheduling, SAD 8-3

setting up rights for running, PSC 6-38

specifying information for, PSC 6-33

specifying parameters for OPSM tasks, PSC 6-37

submitting to job queue, SAD 8-4

trace files, SAD 8-10

troubleshooting, SAD 8-10

join, PLS 7-40

join compatibility, STU 31-9

JOIN KEY clause

of ALTER DIMENSION, SQL 7-25

of CREATE DIMENSION, SQL 7-261

join view, ADG 3 - 28, SAD 15-4

DELETE statements, ADG 3 - 31, SAD 15-7

key-preserved tables in, ADG 3 - 29, SAD 15-5

mergeable, ADG 3 - 29, SAD 15-5

modifying

rule for, ADG 3 - 30, SAD 15-6

UPDATE statements, ADG 3 - 30

when modifiable, ADG 3 - 28, SAD 15-4

join views, SCN 10-15

modifying, SQL 7-440, SQL 7-514, SQL 7-587

joins, DDS 2-25, SQL 5-21, STU 29-10

anti-joins, SCN 24-13

Cartesian products, SCN 23-3

cluster, SCN 10-48, SCN 23-38, SCN 24-5

searches on, SCN 23-40

conditions

defining, SQL 5-21

convert to subqueries, SCN 23-13

cross, SCN 23-3

defined, SCN 23-3

encapsulated in views, SCN 1-24, SCN 10-13

equijoins, SCN 23-3, SQL 5-21

execution plans and, SCN 24-2

for simple subquery snapshots, REP 3-13

full partition-wise, STU 26-52

hash joins, SCN 24-7

index joins, SCN 23-36, SCN 23-49

join order

execution plans, SCN 22-2

selectivity of predicates, SCN 22-8, SCN 22-17

nested loops, SCN 24-2

cost-based optimization, SCN 24-8

nonequijoins, SCN 23-3

optimization of, SCN 24-9

outer, SCN 23-3, SQL 5-22

non-null values for nulls, SCN 24-11

restrictions, SQL 5-22

parallel, and PQ_DISTRIBUTE hint, STU 7-58

partial partition-wise, STU 26-57

partition-wise, SCN 11-5, STU 26-52

partition-wise, examples of full, STU 13-21

partition-wise, examples of partial, STU 13-19

partition-wise, full, STU 13-21

restriction on, PC_ 6-18

sample table scan not supported, SCN 23-34

select-project-join views, SCN 23-15

self, SQL 5-22

semi-joins, SCN 24-13

sort-merge, SCN 24-4

cost-based optimization, SCN 24-9

example, SCN 23-46

star joins, SCN 24-14

star queries, SCN 24-14

views, SCN 1-25, SCN 10-15

without join conditions, SQL 5-22

JPublisher, ADG 1 - 35, GTK 2-20

JQ locks, SAD 8-9

JServer Accelerator, GTK 2-16

JServer. See Java VM

JSQL, GTK 3-13

Julian date, PCO 4-3

Julian day, specifying, SQL 2-42

JVM. See Java VM

---