Index-5
linguistic sorting and string searching, 7-4
loading data
See INSERT statement
local constant, 5-14
local subprogram
in anonymous block, 5-1
in another subprogram, 5-1
in package, 5-11
local variable, 5-14
locale, 7-10
locale-dependent SQL function, 7-8
logical table
See view
long date (DL) format, 7-14
loop statement, 5-21
basic LOOP, 5-26
exiting early, 5-26
FOR LOOP, 5-23
populating associative array with, 5-42
WHILE LOOP, 5-25
M
master script
See installation script
method, 5-39
Microsoft .NET Framework, 1-8
Microsoft Visual Studio, 1-8
monetary format, 7-4
multiline comment in PL/SQL code, 5-4
multilingual applications, 7-1
N
naming convention
for sequences, 4-18
in sample application, 9-3
national character set, 7-5
National Language Support (NLS), 7-1
National Language Support (NLS) parameters
See NLS parameters
native language support, 7-2
NCHAR literal replacement, 7-28
nested subprogram
See local subprogram
nested table, 5-39
.NET assembly, 1-8
.NET stored procedure, 1-8
NEW pseudorecord, 6-3
NEXT collection method, 5-44
NEXTVAL pseudocolumn, 4-18
NLS (National Language Support), 7-1
NLS environment variables, 7-7
NLS parameters
of locale-dependent SQL functions, 7-8
values of
changing, 7-7
initial, 7-5
viewing, 7-6
what they are, 7-1
NLS_CALENDAR parameter, 7-17
NLS_COMP parameter, 7-24
NLS_CURRENCY parameter, 7-20
NLS_DATE_FORMAT parameter, 7-13
NLS_DATE_LANGUAGE parameter, 7-15
NLS_DUAL_CURRENCY parameter, 7-22
NLS_ISO_CURRENCY parameter, 7-21
NLS_LANG parameter, 7-10
NLS_LANGUAGE parameter, 7-10
NLS_LENGTH_SEMANTICS parameter, 7-25
NLS_NUMERIC_CHARACTERS parameter, 7-18
NLS_SORT parameter, 7-22
NLS_TERRITORY parameter, 7-12
NLS_TIMESTAMP_FORMAT parameter, 7-17
nonblocking reads and writes, 8-9
nonprocedural language, 1-5
Not Null constraint, 4-5
adding
with ALTER TABLE statement, 4-6
with Edit Table tool, 4-6
numeric format
elements
C, 7-21
G, 7-18
L, 7-20
in different countries, 7-4
numeric function in query, 2-19
NVL function, 2-26
NVL2 function, 2-26
O
objects
See schema object
OCCI (Oracle C++ Call Interface), 1-6
OCI (Oracle Call Interface), 1-6
ODBC (Open Database Connectivity), 1-7
ODP.NET, 1-8
ODT (Oracle Developer Tools for Visual Studio), 1-8
OLD pseudorecord, 6-3
Open Database Connectivity (ODBC), 1-7
OPEN FOR statement, 8-5
OR REPLACE clause in DDL statement, 4-1
Oracle Application Express, 1-6
Oracle C++ Call Interface (OCCI), 1-6
Oracle Call Interface (OCI), 1-6
Oracle Database Extensions for .NET, 1-8
Oracle Deployment Wizard for .NET, 1-8
Oracle Developer Tools for Visual Studio, 1-8
Oracle Java Database Connectivity (JDBC), 1-6
Oracle Provider for OLE DB (OraOLEDB), 1-9
Oracle Providers for ASP.NET, 1-8
OraOLEDB (Oracle Provider for OLE DB), 1-9
ORDER BY clause of SELECT statement, 2-15
P
package, 5-2
dropping, 5-14
in sample application