background image

<< Indexes - FOUND cursor attribute | Indexes - Oracle Application Express >>

<< Indexes - FOUND cursor attribute | Indexes - Oracle Application Express >>

Indexes - composite structure

Index-2

compile

single-pass, 4-10

composite structure

composite unique constraint

definition, 3-6

conditional predicate, 5-5
connection

HR_CONN, 2-1, 2-2, 3-3, 4-7, 4-8, 6-3, 6-10, 6-11,

6-13, 6-15, 6-1 7, 6-18, 6-20, 6-22, 6-24, 6-26,
6-27, 7-5, 7-8, 7-9, 7-10, 7-11

constant, 1-4, 4-16

definition, 4-15

CONSTANT clause, 4-16
constraint, 1-1, 2-5, 3-6, 7-2, 7-3, 7-10

alter, 7-5
check, 3-6
composite unique, 3-6
disable, 7-2, 7-3, 7-10 , 7-11
disabled, 2-5
enable, 7-2, 7-10, 7-11
enabled, 2-5
find, 7-11
foreign key, 3-6
integrity, 3-6
NOT NULL, 2-28, 3-6
primary key, 3-6
referenced table, 2-5
type, 2-5
unique, 3-6

CONTINUE statement, 4-1
control

CASE, 4-22, 4-24, 4-25
FOR...LOOP, 4-22, 4-25
IF...THEN, 4-24
IF...THEN...ELSE, 4-22
LOOP...EXIT WHEN, 4-22
WHILE...LOOP, 4-22, 4-31

conversion error, 4-43
COUNT function, 4-41
CREATE FUNCTION statement, 4-2, 4-6
CREATE INDEX statement, 3-19, 3-20
CREATE OR REPLACE FUNCTION statement, 4-6
CREATE OR REPLACE PACKAGE BODY

statement, 4-10, 4-14, 4-36

CREATE OR REPLACE PACKAGE statement, 4-10,

CREATE OR REPLACE PROCEDURE

statement, 4-2, 4-4

CREATE OR REPLACE PROCREDURE

CREATE OR REPLACE TRIGGER statement, 5-5,

CREATE OR REPLACE VIEW statement, 3-24
CREATE PACKAGE BODY statement, 4-14
CREATE PACKAGE statement, 4-12
create PL/SQL object, 7-8
Create PL/SQL Package, 4-11
CREATE PROCEDURE statement, 4-2, 4-6
CREATE SEQUENCE statement, 3-27

CREATE statement, 1-2, 3-1, 5-2, 5-3, 7 -2, 7-4, 7-5
CREATE SYNONYM statement, 3-29, 3-30
CREATE TABLE statement, 3-1, 3-5, 3-6 , 3-20, 5-4 ,

5-5, 6 -26, 6-27, 6-28, 6-29, 7-5, 7-8

CREATE TRIGGER statement, 5-2, 5-3, 5-9
CREATE VIEW statement, 3-21, 3-22, 3 -25, 5-7, 7-5
CREATED_BY column, 7-7
CREATED_ON column, 7-7
CURRVAL pseudocolumn, 3-25
cursor

CLOSE, 4-34
definition, 4-32
explicit, 4-33
implicit, 4-33
OPEN, 4-33

cursor attribute

%FOUND, 4-33
%ISOPEN, 4-33
%NOTFOUND, 4-33
%ROWCOUNT, 4-33

CURSOR_ALREADY_OPEN exception, 4-42

D

data

manipulate, 2-1
query, 2-1

data definition language, 1-2
data integrity, 1-1
data manipulation language, 1-2
data model, 1-1
data persistence tier, 1-1
data storage, 1-2
database

database client

SQL Developer, 1-1
SQL*Plus, 1-1

database components, 1-1
database object

DATE type, 4-9, 4-15
DBMS_OUTPUT.PUT procedure, 4-25
DBMS_OUTPUT.PUT_LINE procedure, 4-24
DDL, 1-2

definition, 1-2

declarative computer language

definition, 1-4

declarative language, 1-3
DECLARE CURSOR statement, 4-33
DECLARE keysord, 4-2
DECLARE keyword, 4-19
DECODE function, 2-27
DELETE statement, 1-2, 2-29, 4-33, 5-2, 5-4, 7-12

definition, 2-27

DELETING conditional predicate, 5-5
DENSE_RANK function, 2-25
DEPARTMENTS_SEQ sequence, 3-25
development environment, 1-7, 1-10

Open Database Connectivity, 1-12