Skip Headers
Oracle® Database 2 Day + .NET Developer's Guide
11g Release 2 (11.2)

E10767-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  T  U  V  W 

A

accounts
unlocking, 5.2, 8.3
Add() method, 4.3
adding references, 3.2
alias
database, 5.2
ALTER TABLE, 5.5
anonymous users
denying, 7.6
apply filters, 5.2, 8.3
ASP.NET Configuration, 7.5
ASP.NET tutorial, 7.2
ASP.NET user schema, 2.4.1
ASP.NET Web Sit Administration Tool, 7.5
ASPNET_DB_USER, 2.4.1
authentication
web site, 7.4
automatic naming, 3.1

B

before beginning ASP.NET tutorial, 7.2
bind variables
name, 4.3
position, 4.3
binding data, 4.5
building an ASP.NET Application with ODT, 7.1
building connection, 3.5
button control, 3.4

C

C# statements
using, 3.3
case statements, 3.7.3
class variables, 4.5
click events, 4.5
client globalization settings, 9.5.1
CLR (Common Language Runtime), 1.2
Code and Designer toggle, 3.4
Code view, 3.3
commands
query, 4.1
using, 4.1
CommandType property, 4.1
Common Language Runtime (CLR)
agent, 8.2
definition, 1.2
Service
starting, 8.2
configuration scripts, 2.4
configuring an OracleConnection window, 8.6
configuring Oracle Providers for ASP.NET
all, 2.4.1.2
individually, 2.4.1.3
connect alias, 2.3
connect descriptor, 2.3
connecting, 5.2
as SYSDBA, 8.3, 8.6
connecting web site to database, 7.3
connection
add, 8.3
building, 3.5
data source names, 5.2, 5.2, 8.3
details, 8.3
dispose, 4.5
hr, 8.3
name, 5.2
new, 8.3
opening, 3.5
password, 5.2, 5.2
role, 5.2
specific user name and password, 5.2
user name, 5.2, 8.3
user name and password, 8.3
connection control, 3.4
connection strings
setting for ASP.NET, 2.4.2
constraints
add, 5.5
properties, 5.5
tab, 5.5
controls, 3.4
button, 3.4
DataGrid, 4.4
Label, 3.4, 3.4
Listbox, 4.2
Textbox, 3.4
toolbox, 3.4
copying a form, B
creating a user, 2.4.1
creating a web site, 7.3
creating a web user, 7.5
creating an Oracle Project, 8.4
cultural conventions, 9.1
Culture parameter (ID), 9.4
CultureInfo object, 9.2
culture-sensitive data, 9.5
CurrentCulture parameter, 9.5.3
customizing Oracle Providers for ASP.NET, 2.4.3

D

data entry control, 3.4
data grid, 6.6
data provider, 3.2
Oracle Data Provider for .NET, 1.3
Data Source Configuration wizard, 7.3.2
data source names, 5.2, 8.3
database error messages, 3.7.3
DataGrid class, 6.6
DataGrid control, 4.4
DataReader class, 4.4
DataSet class, 4.5
updating, 9.5.2
date formats, 9.3.2
change, 9.5.2
default roles, 5.2
Default.aspx, 7.4
deleting data, 4.7
Design view, 5.3
Designer, 3.4
Designer and Code toggle, 3.4
designing user interfaces, 3.4
dialog
new projects, 3.1
Direction property, 4.3
display schema, 5.2, 8.3
Dispose() method, 3.7.1
documentation library, 1.1

E

enabling a web site for authentication, 7.4
enabling Oracle Providers for ASP.NET, 7.5
Enterprise Manager, 2.1.1, 8.6
error handling
exceptions with ODP.NET, 3.7
ODP.NET, 3.7
Oracle, 3.7
Try-Catch-Finally, 3.7.1
error messages, 9.3.5
Error property, 3.7
events
click, 4.5
examples
names of, 3.1
Exception class, 3.7.3
ExecuteReader() method, 4.2

F

FCL (Framework Class Libraries), 1.2
File menu, 3.1, 3.1
finally block, 4.5
foreign key, 5.5
Form1, 3.1
form1.cs, 3.1
form1.vb, 3.1
forms, 3.4
Framework Class Libraries (FCL)
definition, 1.2

G

GetSessionInfo() method, 9.5.2
GetThreadInfo() method, 9.5.3
global applications
development, 9.1
introduction, 9.1
.NET framework, 9.2
globalization
definition, 9.2
session information, 9.5.2
globalization support
client, 9.5
ODP for .NET, 9.5
granting privileges, 2.4.1
Grant/Revoke Privileges Wizard in ODT, 2.4.1
GridView control, 7.3

H

HR schema, 2.1.2

I

Imports statement, 3.3
indexes
add, 5.4
creating, 5.4
properties, 5.4
Indexes tab, 5.4
inserting data, 4.7
InstallOracleASPNETCommon.sql, configuration, 2.4

L

Label control, 3.4, 3.4
linguistic sorts, 9.3.4
ListBox, 4.2
local user conventions, 9.3
locale
awareness, 9.1
characteristics, 9.1
definition, 9.1
synchronizing, 9.4
localization
resources, 9.2
lock, 5.2, 8.3
login.aspx, 7.4

M

machine.config, 2.4
memory location, 6.3
menus
File, 3.1, 3.1
View, 3.4
method parameters
binding, 6.6
definition, 6.6
methods
Add(), 4.3
Dispose(), 3.7.1
Open(), 3.5
Microsoft internationalization
URL, 9
Microsoft .NET Framework
definition, 1.2
Microsoft Visual Studio, 1.5
2005, 1.1
2008, 1.1

N

name of code files, 3.1
name of forms, 3.1
Name property, 3.4
namespace directives, 3.3
.NET assembly, 1.5
NET connect, 2.3
.NET languages, 1.4
.NET stored functions and procedures
creating, 8.5
deploying, 8.6
running, 8.7
.NET stored procedure, 1.5
.NET Stored Procedures, 2.1.1
.NET stored procedures, 1.4, 2.1.4
deployment, 8.2
.NET Types, 9.5.3
New Package Window, 6.4, 6.5
New Project dialog, 3.1
NLS error messages setting, 9.3.5
NLS number formats
settings, 9.3.3
NLS sort order, 9.3.4
NLS_LANG parameter, 9.5, 9.5.1
NLS_LANGUAGE parameter, 9.3.2, 9.3.5, 9.4
NLS_SORT parameter, 9.3.4
NLS_TERRITORY parameter, 9.3.2, 9.3.3, 9.4

O

ODAC (Oracle Data Access Components), 2.2
ODP.NET Types, 9.5.3
Open() method, 3.5, 9.5
opening connection, 3.5
Oracle Data Access Components (ODAC), 2.1.3
downloading, 2.2
Oracle Data Provider for .NET, 2.1.1
using, 4
Oracle Data Provider for .NET (ODP.NET)
definition, 1.3
globalization, 9.1
installation, 2.2
Oracle Database, 2.1.1
documentation library, 1.1
installation, 2.1.1
Oracle Database Extensions for .NET
installing, 2.1.4
upgrades, 2.1.4
Oracle date formats, 9.3.2
Oracle Deployment Wizard for .NET, 1.5, 8.6
Oracle Developer Tools
definition, 1.4
features
designer, 1.4
drag and drop, 1.4
dynamic help, 1.4
Oracle Data Window, 1.4
Oracle Query Window, 1.4
PL/SQL editor, 1.4
wizard, 1.4
installation, 2.2
using, 5.1
Oracle error messages, 9.3.5
Oracle linguistic sorts, 9.3.4
Oracle number formats, 9.3.3
Oracle Projects
creating, 8.4
Oracle Providers for ASP.NET, 2.4.1.2
configuring individually, 2.4.1.3
customizing, 2.4.3
enabling, 7.5
setup, 2.4
Oracle Universal Installer (OUI), 2.2
ORACLE_BASE\ORACLE_HOME, 2.2
OracleClrAgent service, 8.2
OracleCommand class, 4.1, 4.2, 4.3
using stored procedure, 6.6
OracleConnection class, 3.5, 9.5
GetSessionInfo() method, 9.5.2
Open() method, 9.5
OracleDataAccess.dll, 3.2
OracleDataReader class, 4.2, 4.2, 4.4, 4.5
OracleDbType property, 4.3, 4.3
OracleError class, 3.7
OracleErrorCollection class, 3.7
OracleException class, 3.7, 3.7.3
OracleGlobalization
class, 9.5.2
GetClientInfo() method, 9.5.1
OracleGlobalization class
GetThreadInfo() method, 9.5.3
SetThreadInfo() method, 9.5.3
OracleParameter class, 4.3, 6.6
OracleParameterCollection class, 4.3
OracleRefCursor class, 6.3
OracleService, A
OraProvCfg, 2.4
OUI (Oracle Universal Installer), 2.2

P

package bodies, 6.2
package interfaces, 6.2
PACKAGE types, 6.2
packages
new, 6.4, 6.5
ParameterName, 4.3
passwords
save, 5.2
PL/SQL packages
body, 6.2
definition, 6.2
interface, 6.2
introduction, 6.2
PL/SQL stored procedures
definition, 6.1
in ODP.NET, 6.6
introduction, 6.1
REF CURSORs, 6.4, 6.5
preview SQL, 5.3, 6.4, 6.5
primary key
column, 5.5
privileges
granting, 2.4.1
projects
add reference, 3.2
new, 3.1
solution, 3.1
type
Visual Basic, 3.1
Visual C#, 3.1
properties
Direction, 4.3
Error, 3.7
OracleDBType, 4.3
OracleDBType property, 4.3
ParameterName, 4.3
Size, 4.3
Value, 4.3
Properties window, 3.4

Q

query performance, 4.3
Query Window
running .NET procedures, 8.8
query work area
definition, 6.3

R

Rebuild Solution, 3.7.2
records, 4.7
add, 5.6
REF CURSORs
accessibility, 6.3
assigning, 6.4, 6.5
definition, 6.3
introduction, 6.3
PL/SQL data type, 6.3
PL/SQL stored procedures, 6.4, 6.5
references
adding, 3.2
result set, 6.3
retrieving data
accessor type, 4.2
bind variables, 4.3
from Oracle, 7.3
looping, 4.4
multiple columns, 4.4
multiple rows, 4.4
multiple values, 4.4
simple query, 4.2
value methods, 4.2
roles
user default, 5.2
Run Function window, 8.7
running .NET procedures in Query Window, 8.8
running .NET procedures in SQL, 8.8

S

sample data, 2.1.2
sample schemas, 2.1.2
Save command, 3.3
schema object, 1.4, 8.3
schemas
display, 5.2, 8.3
security, 7.1
SELECT statements
bind variables, 4.3
simple, 4.3
Server Explorer, 1.4, 6.5
using, 5.2
service_name, A
Services, A
session globalization setting, 9.5.2
SetThreadInfo() method, 9.5.3
setup for Oracle Providers for ASP.NET, 2.4
simple query, 4.2
Size property, 4.3
solution, 3.1
specify copy options window, 8.6
specify deployment option window, 8.6
specify methods and security details window, 8.6
SQL preview, 5.3
SQL query, 4.1
SQL statement string, 4.1
SQL*Plus, 9.3.2
connecting to, 9.3.1
sqlnet.ora, 2.3
start Oracle Database Instance, A
Start Without Debugging, 7.6
statements
case, 3.7.3
Imports, 3.3
optimizing, 4.3
parsing, 4.3
reusing, 4.3
using, 3.3
stop Oracle Database Instance, A
stored procedures
creating Oracle Project to hold, 8.4
definition, 6.1
run, 8.7
Summary
of deployment, 8.6
SYSDBA
connecting as, 8.6
System.Globalization, 9.2
System.Resources, 9.2
System.Threading.Thread.CurrentThread.CurrentCulture parameter, 9.5.3

T

table design views, 5.4
table design windows, 5.3
tables
add data, 5.6
constraint name, 5.5
constraint properties, 5.5
constraints, 5.5
add, 5.5
creating, 5.3
data, 5.6
grid, 5.6
new, 5.3
new relational, 5.3
query, 5.7
record, 5.6
relational, 5.3
retrieve data, 5.6
simple query, 5.7
testing
web site authentication, 7.6
Text property, 4.2
Textbox control, 3.4
thread-based globalization setting, 9.5.3
tnsnames.ora, A
configuring, 2.3
toolbox, 3.4
try code block, 4.1, 4.5
Try-Catch-Finally block, 3.7.1
Try-Catch-Finally error handling, 3.7.1
tutorial, 7.2

U

unlocking accounts, 5.2, 8.3
unlocking user account
Oracle Database interface, 8.6
updating data
bind variable, 4.3
user interfaces
designing, 3.4
user schema
ASPNET_DB_USER, 2.4.1
user_source view, 6.2
users
creating, 2.4.1
locale settings, 9.4
role, 5.2, 8.3
using statements, 3.3

V

Value property, 4.3
variable declarations, 4.5
View menu, 3.4
views
Design, 5.3
table design, 5.4
user_source, 6.2
Visual Basic (VB) statements
Imports, 3.3
Visual Studio, 1.5
versions, 2.1.5

W

warning
in error handling, 3.7
web site
connecting to database, 7.3
creating, 7.3
web site authentication, 7.4
testing, 7.6
web users
creating, 7.5
Windows Registry, 9.5, 9.5.1