Index
A B C D E F G H I L M N O P Q R S T U V W X Z
A
- account
-
- unlocking, 5.1, 7.3
- Add Connection window, 5.1, 7.3, 7.5
- Add Method window, 6.4, 6.4
- add reference, 3.2
- Add Reference dialog, 3.2
- Add() method, 4.4
- adding
-
- reference, 3.2
- adding reference, 3.2
- alias
-
- database, 5.1
- ALTER TABLE, 5.4, 5.4
- application
-
- result, 4.4
- run, 3.6, 3.7, 3.7, 4.3, 4.5, 4.6, 5.6, 5.7, 6.5
- apply filters, 5.1, 7.3
B
- bind variable, 4.4
-
- definition, 4.4
- identifier, 4.4, 4.4
- name, 4.4, 4.4
- position, 4.4, 4.4
- update, 4.4
- BindByName property, 4.4
- binding data, 4.6, 4.6
- build
-
- deploy solution, 7.5
- success, 7.4
- Build menu, 7.4, 7.5
- build solution, 7.4
- building connection, 3.5, 3.5
- button, 3.4, 4.6
-
- disable, 3.5, 3.6
C
- C
-
- HRVisual Studio Projects directory, 4.1
- C# statement
-
- using, 3.3
- Case statement, 3.7
- class variable, 4.6
- Click event, 3.4
- click event, 4.6
- client globalization settings, 8.5.1
- close connection, 3.8
- CLR, 1.1
- Code view, 3.3
- code view, 5.6, 5.7, 6.5
- column
-
- add, 5.2
- data type, 5.2
- name, 5.2
- property, 5.2
- size, 5.2
- command
-
- database query, 4.2, 4.2
- definition, 4.2
- query, 4.2, 4.2
- using, 4.2
- CommandType property, 4.2
- Common Language Runtime
-
- definition, 1.1
- Common Language Runtime Host for Oracle Database, 1.4
- Common Language Runtime Service
-
- starting, 7.1
- Configure Your Connection window, 7.5
- connect, 5.1
- connect project, 3.2
- connect_Click() method, 3.4, 3.5, 4.6, 4.6, 6.5
- connection
-
- add, 5.1, 7.3, 7.5
- building, 3.5, 3.5
- close, 3.8
- creating, 7.3
- data, 5.1, 5.6, 7.3
- data source name, 5.1, 5.1, 7.3, 7.3, 7.5
- detail, 5.1
- details, 7.3
- dispose, 4.6
- hr. (Local Database), 5.6
- hr.(Local Database), 5.1, 7.3
- hr.(LocalDatabase), 7.6
- name, 5.1, 7.3
- new, 7.3, 7.5
- opening, 3.5, 3.5
- password, 5.1, 5.1, 7.3, 7.5
- role, 5.1
- saving password, 5.6
- specific user name and password, 5.1
- SYSDBA, 7.5
- table, 5.6
- test, 5.1, 7.3, 7.5
- test failure, 5.1, 7.3
- test success, 5.1
- user name, 5.1, 5.1, 7.3, 7.3
- user name and password, 7.3
- username, 7.5
- connection element, 3.4
- constraint
-
- add, 5.4, 5.4
- constraint properties, 5.4, 5.4
- Constraints tab, 5.4
- copy project, 4.1
- CREATE TABLE, 5.2
- cultural convention, 8.1
- cultural conventions, 8
- culture conventions, 8.5
- Culture ID parameter, 8.4
- Culture parameter, 8.4
- CultureInfo, 8.2
- culture-sensitive data, 8.5
- CurrentCulture parameter, 8.5.3
D
- data
-
- navigate, 5.6
- sort, 5.6
- Data Access for .NET Classes, 1.4
- data connection, 5.1, 5.6
- data entry element, 3.4
- Data Grid, 4.6
- data grid, 4.6, 4.7, 6.5
- data provider, 3.2
-
- Oracle Data Provider for .NET, 1.2
- data source name, 5.1, 7.3
- database error message, 3.7, 3.7
- DataGrid, 4.5
- DataGrid class, 5.6, 5.6, 5.6, 5.6, 6.5
-
- filling, 5.6, 5.6
- properties, 5.6
- DataReader class, 4.5, 4.5, 4.5
- DataSet class, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6
-
- definition, 4.6
- generate, 5.6
- updating, 8.5.2, 8.5.2
- DataSource parameter, 5.6
- date
-
- format, 8.3.1
- date format, 8.3.1
-
- change, 8.5.2, 8.5.2
- long, 8.3.1
- settings, 8.3.1
- short, 8.3.1
- standard, 8.3.1
- Debug menu, 3.6
- default role, 5.1, 7.3
- DELETE statement, 4.4
- deleting data, 4.7
- design property, 4.3
- Design view, 3.4, 3.4, 4.3, 4.6, 5.2, 5.2, 5.3, 5.6, 6.4, 6.4, 6.4
- Design window, 5.6, 5.6
- Designer window, 5.6
- dialog
-
- New Project, 7.2, 7.2
- new project, 3.1, 3.1
- Direction property, 4.4, 4.4, 4.4
- disable button, 3.5, 3.6
- display schema, 5.1, 7.3
- Dispose() method, 3.7, 3.7, 3.8
E
- Easy Connect
-
- syntax, 3.5
- edit package body, 6.4
- error handling, 3.7
-
- Try-Catch-Finally, 3.7, 3.7
- type
-
- exceptions with ODP.NET, 3.7
- ODP.NET, 3.7
- Oracle, 3.7
- error message, 8.3.4
- Error property, 3.7
- event
-
- click, 3.4
- Events icon, 3.4
- Exception class, 3.7
- ExecuteReader() method, 4.3
- EZ Connect Adapter, 3.5
F
- FCL, 1.1
- File menu, 3.1, 3.3, 7.2
- finally block, 4.6
- foreign key, 5.4, 5.4
- Framework Class Libraries
-
- definition, 1.1
G
- GetClientInfo() method, 8.5.1
- GETCURSORS method, 6.4
- GETCURSORS procedure, 6.4
- GETDEPARTMENTNO procedure, 7.6
- getDepartmentno(), 7.4, 7.4
- getDepartmentno() method, 7.4, 7.5
- GetSessionInfo() method, 8.5.2
- GetThreadInfo() method, 8.5.3
- global application
-
- deployment, 8
- development, 8
- .NET framework, 8.2
- planning, 8.2
- global applications
-
- introduction, 8.1
- globalization
-
- definition, 8.2
- globalization session information, 8.5.2, 8.5.2
- globalization support, 8.5
-
- client, 8.5
- ODP for .NET, 8.5
- globalization support features, 8
H
- handling errors, 3.7
- host, 3.5
- HR_Connect_CS folder, 4.1, 4.1
- HR_Connect_CS project, 3.1, 4.6
- HR_Connect_CS solution, 4.1, 4.1
- HR_Connect_VB folder, 4.1
- HR_Connect_VB project, 3.1, 4.6
- HR_Connect_VB solution, 4.1
- HR_DATA package, 6.4, 6.4, 6.4
- HR_DataSet_ODP_CS project, 4.6, 6.4
- HR_DataSet_ODP_VB project, 4.6
- HR_DeployStored_CS project, 7.2, 7.5
- HR_DeployStored_VB project, 7.2, 7.5
- HR_Globalization_CS project, 8.5.2
- HR_Globalization_VB project, 8.5.2
- HR_ODP_CS folder, 4.1, 4.1
- HR_ODP_CS solution, 4.1, 4.1, 4.1
- HR_ODP_VB folder, 4.1
- HR_ODP_VB solution, 4.1, 4.1, 4.1
- HR_ODT_CS project, 5.1
- HR_ODT_VB project, 5.1
- HR_StoredProcedure_CS project, 6.4
- HR_StoredProcedure_VB project, 6.4
I
- Imports statement, 3.3
- index
-
- add, 5.3
- add key, 5.3
- creating, 5.3
- key, 5.3
- name, 5.3
- property, 5.3
- Indexes tab, 5.3
- initial programmatic statement, 3.3
-
- C#, 3.3
- VB, 3.3
- InitializeComponent() method, 5.6
- INSERT statement, 4.4
- inserting data, 4.7
- InstallShield wizard, 2.2
L
- Label, 3.4
- label, 4.3
- language
-
- sorting rules, 8.3
- lightning icon, 3.4
- linguistic sort, 8.3.3
- list box, 4.3
- ListBox, 4.3, 4.5
- literal quotation marks, 4.4
- local user convention, 8.3
- locale
-
- definition, 8.1
- synchronizing, 8.4
- locale awareness, 8
- locale characteristics
-
- definition, 8.1
- localization
-
- definition, 8.2
- resources, 8.2
- LTER TABLE, 5.4
M
- memory address, 6.3
- memory location, 6.3
- menu
-
- Build, 7.4
- build, 7.5
- Debug, 3.6
- File, 3.3, 7.2
- file, 3.1
- Project, 3.2
- View, 3.2, 3.3, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.6, 4.6, 5.1
- method
-
- add, 6.4
- Add(), 4.4
- connect_Click(), 3.5, 6.5
- detail, 7.5
- Dispose(), 3.7, 3.7, 3.8
- GETCURSORS, 6.4
- getDepartmentno(), 7.5
- name, 6.4
- Open(), 3.5, 3.5
- parameter, 6.4
- save_Click(), 5.7
- type, 6.4
- method parameter
-
- add, 6.4
- binding, 6.5
- data type, 6.4
- definition, 6.5
- detail, 6.4
- direction, 6.4
- name, 6.4
- Microsoft Development Environment window, 5.6
- Microsoft internationalization
-
- URL, 8
- Microsoft .NET Framework
-
- definition, 1.1
N
- Name property, 3.4, 3.4, 4.6
- name property, 4.3
- navigate
-
- data, 5.6
- records, 5.6
- .NET assembly, 1.4
- .NET framework, 8.2
- .NET languages, 1.3
- .NET stored functions and procedures
-
- creating, 7.4
- deploying, 7.5
- running, 7.6
- .NET Stored Procedures, 2.1
- .NET stored procedures, 1.3
-
- deployment, 7
- .NET Types, 8.5.3
- New Package window, 6.4, 6.4, 6.4
- new project, 3.1
- New Project dialog, 3.1, 3.1, 7.2
- NLS error messages setting, 8.3.4
- NLS number format
-
- settings, 8.3.2
- NLS Registry, 8.5.2
- NLS sort order, 8.3.3
- NLS_LANG, 8.5.1
- NLS_LANG parameter, 8.5, 8.5
- NLS_LANGUAGE parameter, 8.3.1, 8.3.1, 8.3.4, 8.3.4, 8.3.4, 8.4, 8.4
-
- common, 8.4
- NLS_SORT parameter, 8.3.3, 8.3.3
- NLS_TERRITORY parameter, 8.3.1, 8.3.1, 8.3.2, 8.3.2, 8.4, 8.4
-
- common, 8.4
- number format, 8.3.2
O
- ODBC, 2.1
- ODP.NET
-
- definition, 1.2
- globalization, 8
- ODP.NET Types, 8.5.3, 8.5.3
- OLE DB, 2.1
- OPD.NET
-
- using, 5
- Open() method, 3.5, 3.5, 8.5
- opening connection, 3.5, 3.5
- Oracle Application Express, 2.1, 7.5
- Oracle Data Provider for .NET, 2.1, 3.2
-
- definition, 1.2
- using, 4
- Oracle Database Extensions
-
- features
-
- Common Language Runtime Host for Oracle Database, 1.4
- Data Access for .NET Classes through Oracle Data Provider for .NET, 1.4
- Oracle Deployment Wizard for .NET, 1.4
- Oracle Deployment Wizard for Visual Studio .NET, 1.4
- Oracle Database XE, 2.1
-
- client, 2.1
- server, 2.1
- Oracle date format, 8.3.1
- Oracle Deployment Wizard, 7.5, 7.5
- Oracle Deployment Wizard for Visual Studio .NET, 1.4
- Oracle Developer Tools
-
- definition, 1.3
- features
-
- designer, 1.3
- drag and drop, 1.3
- dynamic help, 1.3
- Oracle Data Window, 1.3
- Oracle Explorer, 1.3
- Oracle Query Window, 1.3
- PL/SQL editor, 1.3
- Solution Explorer, 3.2
- wizard, 1.3
- installation, 2.2
- testing installation, 2.3
- Oracle Developer Tools for Visual Studio .NET
-
- using, 5
- Oracle error message, 8.3.4
- Oracle Explorer, 5.1, 5.1, 5.2, 5.4, 5.5, 5.6, 6.4, 6.4, 6.4, 7.3, 7.3, 7.6
- Oracle Globalization Registry, 8.5.2
- Oracle globalization setting, 8.5.1
- Oracle globalization settings, 8.5.1
- Oracle linguistic sort, 8.3.3
- Oracle number format, 8.3.2
- Oracle project
-
- creating, 7.2
- OracleCommand
-
- using stored procedure, 6.5, 6.5
- OracleCommand class, 4.2, 4.2, 4.3, 4.4, 4.4
- OracleConnection, 3.5
- OracleConnection class, 3.5, 3.5, 5.6, 8.5, 8.5.2
-
- GetSessionInfo() method, 8.5.2
- Open() method, 8.5
- Oracle.DataAccess, 3.2
- OracleDataAccess.dll, 3.2, 3.2
- OracleDataAdapter class, 5.6
- OracleDataReader class, 4.3, 4.3, 4.3, 4.5, 4.6
- OracleDbType property, 4.4, 4.4
- OracleError class, 3.7, 3.7
- OracleErrorCollection class, 3.7
- OracleException class, 3.7, 3.7, 3.7
- OracleGlobalization, 8.5.1
- OracleGlobalization class, 8.5.2, 8.5.3, 8.5.3
-
- GetClientInfo() method, 8.5.1
- GetThreadInfo() method, 8.5.3
- SetThreadInfo() method, 8.5.3
- OracleGlobalization.GetClientInfo(), 8.5.1
- OracleGlobalization.GetClientInfo() method, 8.5.1
- OracleParameter class, 4.4, 4.4, 6.5, 6.5
- OracleParameterCollection class, 4.4, 4.4
- OracleRefCursor class, 6.3
- OracleServiceXE, 3.7, 3.7
- OracleXEClrAgent, 7.1, 7.1
- OracleXEClrAgent service, 7.1, 7.1
- order
-
- ascending, 5.6
- descending, 5.6
- Output window, 6.4, 7.4
P
- package
-
- edit body, 6.4
- HR_DATA, 6.4, 6.4, 6.4, 6.4
- name, 6.4
- new, 6.4
- save, 6.4
- package body, 6.1
- PACKAGE BODY type, 6.1
- package interface, 6.1
- package specification, 6.1
- PACKAGE type, 6.1
- parameter, 6.4
- parameter detail, 6.4, 6.4
- ParameterName property, 4.4
- password, 3.5
-
- save, 5.1, 5.6
- saving, 7.3
- set, 7.5
- PasswordChar property, 3.4
- PL/SQL package
-
- body, 6.1
- definition, 6.1
- interface, 6.1
- specification, 6.1
- PL/SQL package bodies, 6.1
- PL/SQL packages
-
- introduction, 6.1
- PL/SQL stored procedure
-
- definition, 6.2
- in ODP.NET, 6.5
- introduction, 6.2
- ref cursor, 6.4
- PL/SQL stored procedures, 6
- port, 3.5
- preview SQL, 5.2, 5.3, 6.4
- Preview SQL window, 5.2, 5.3, 5.3, 5.4, 5.4, 6.4
- primary key, 5.4
-
- column, 5.4
- procedure
-
- GETCURSORS, 6.4
- GETDEPARTMENTNO, 7.6
- run, 7.6
- value, 6.4, 6.4, 6.4
- project
-
- add reference, 3.2
- connect, 3.2
- connection, 3.2
- copy, 4.1
- HR_Connect_CS, 3.1, 4.6
- HR_Connect_VB, 3.1, 4.6
- HR_DataSet_ODP_CS, 4.6, 6.4
- HR_DataSet_ODP_VB, 4.6
- HR_DeployStored_CS, 7.2, 7.5
- HR_DeployStored_VB, 7.2, 7.5
- HR_ODT_CS, 5.1
- HR_ODT_VB, 5.1
- HR_StoredProcedure_CS, 6.4
- HR_StoredProcedure_VB, 6.4
- location, 3.1, 7.2
- name, 3.1, 7.2, 7.2
- new, 3.1, 3.1, 7.2
- solution, 3.1
- template, 3.1, 7.2
- type, 3.1, 3.1, 7.2
-
- Visual Basic, 3.1, 7.2
- Visual C#, 3.1, 7.2
- Project menu, 3.2
- propert
-
- text, 4.6
- properties
-
- data, 5.6
- Properties window, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.3, 4.6, 4.6, 4.6, 5.6, 5.6
- property, 3.4, 3.4, 3.4, 4.6, 4.6
-
- appearance, 3.4, 4.6
- behavior, 3.4
- BindByName, 4.4
- design, 3.4, 3.4, 4.3, 4.6, 4.6
- Direction, 4.4, 4.4, 4.4
- Error, 3.7
- Name, 3.4, 3.4, 4.6
- name, 4.3
- OracleDBType, 4.4
- OracleDbType, 4.4
- ParameterName, 4.4
- PasswordChar, 3.4
- Size, 4.4, 4.4, 4.4
- Text, 3.4, 3.4, 3.4, 4.3
- Value, 4.4, 4.4
Q
- query performance, 4.4
- query work area
-
- definition, 6.3
R
- record, 4.7, 5.5
-
- add, 5.5
- delete, 4.7
- navigate, 5.6
- sort, 5.6
- REF cursor, 6
- ref cursor
-
- accessibility, 6.3
- assigning, 6.4
- database round trip, 6.3
- database update, 6.3
- definition, 6.3
- introduction, 6.3
- PL/SQL datatype, 6.3
- PL/SQL stored procedure, 6.4
- reading, 6.3
- read-only, 6.3
- serial, 6.3
- reference
-
- add, 3.2
- adding, 3.2, 3.2
- folder, 3.2
- list, 3.2
- rename solution, 4.1
- resources
-
- deploying, 8.2
- localization, 8.2
- packaging, 8.2
- result set, 6.3
- retrieving data
-
- accessor type methods, 4.3
- bind variable, 4.4, 4.4, 4.4
- looping, 4.5, 4.5
- multiple column, 4.5
- multiple row, 4.5
- multiple values, 4.5
- native data type, 4.3
- native Oracle data type, 4.3
- simple query, 4.3
- value, 4.3, 4.3
- zero-based ordinal, 4.3
- role, 7.3
-
- user, 5.1
- user default, 5.1
- row, 5.5
- row set, 6.3
- run
-
- application, 4.5, 5.7
- Run application, 3.7
- run application, 3.6, 3.7, 4.3, 4.6
- Run Function window, 7.6
- Run Procedure window, 6.4
- running an application, 5.6
S
- Sample Data, 2.1
- sample data, 2.1
- Sample Schema, 2.1
- Save button, 5.7
- Save icon, 3.3
- save_Click() method, 4.6, 4.6, 5.7, 5.7, 5.7
- schema
-
- content, 5.1
- display, 5.1, 7.3
- schema object, 1.3, 7.3
- SELECT statement, 4.4, 4.4
-
- bind variable, 4.4
- simple, 4.4
- service_name, 3.5
- services, 7.1
- session globalization parameter, 8.5.2
- session globalization setting, 8.5.2
- SetThreadInfo() method, 8.5.3
- Setup file, 2.2
- Setup icon, 2.2
- simple query, 4.3
- Size property, 4.4, 4.4, 4.4
- software download, 2.2
- solution, 3.1
-
- deploy, 7.5
- Solution 'HR_Connect_CS', 4.1
- Solution 'HR_Connect_VB', 4.1
- Solution Explorer, 3.2, 3.2, 3.2, 3.2, 3.2, 3.4, 4.1, 4.1
- sort
-
- data, 5.6
- records, 5.6
- Specify an assembly and library name window, 7.5
- Specify copy options window, 7.5
- Specify methods and security details window, 7.5
- Specify your deployment option window, 7.5
- SQL
-
- preview, 5.2
- SQL injection attack, 4.4
- SQL preview, 5.3
- SQL query, 4.2
- SQL statement, 4.4, 4.4, 4.4, 4.4, 5.3
- SQL statement string, 4.2, 4.2
- SQLPlus, 8.3.1
- Start Database window, 3.7
- statement
-
- Case, 3.7
- DELETE, 4.4
- Imports, 3.3
- INSERT, 4.4
- memory, 4.4
- optimizing, 4.4
- parsing, 4.4
- reusing, 4.4
- UPDATE, 4.4
- using, 3.3
- stored procedure, 4.4
-
- definition, 6.2
- run, 6.4
- stored procedure declaration, 4.4
- Summary window
-
- window
-
- Summary, 7.5
- System.Globalization, 8.2
- System.Resources, 8.2
- System.Threading.Thread.CurrentThread.CurrentCulture parameter, 8.5.3
T
- table
-
- add constraint, 5.4
- add data, 5.5
- constraint, 5.4, 5.4
-
- add, 5.4, 5.4, 5.4
- association, 5.4
- local column, 5.4
- primary key, 5.4
- referenced column, 5.4
- constraint name, 5.4
- constraint properties, 5.4, 5.4
- constraint type, 5.4
- creating, 5.2
- data, 5.5
- grid, 5.5
- name, 5.2
- new, 5.2
- new relational, 5.2
- query, 5.6
- record, 5.5
- relational, 5.2
- retrieve data, 5.5
- row, 5.5
- simple query, 5.6
- SQL form, 5.2
- table design view, 5.3, 5.4
- table design window, 5.2
- table grid, 5.5
- test
-
- result, 7.5
- test result window, 7.5
- Text Box, 3.4
- Text property, 3.4, 3.4, 3.4, 4.3, 4.6
- thread-based globalization setting, 8.5.3
- Toolbox, 3.4, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.3, 4.6, 4.6, 4.6, 4.6, 4.6, 5.6
- try code block, 4.2, 4.6, 6.5
- Try-Catch-Finally, 3.7, 3.7
- Try-Catch-Finally error handling, 3.7, 3.7
- type of project, 3.1
U
- unlocking account, 5.1, 7.3
- unlocking user account, 2.3
-
- Oracle XE Database interface, 2.3, 7.5
- update event, 5.7
- UPDATE statement, 4.4
- updating data, 4.7
-
- bind variable, 4.4
- user
-
- default role, 7.3
- id, 3.5
- locale settings, 8.4
- role, 5.1, 7.3
- user's locale, 8.1
- user_source view, 6.1
- using statement, 3.3
V
- Value property, 4.4, 4.4
- variable declaration, 4.6
- VB statement
-
- Imports, 3.3
- view
-
- Code, 3.3
- code, 5.6, 5.7, 6.5
- Design, 3.4, 3.4, 4.3, 4.6, 5.2, 5.2, 5.3, 5.6, 6.4, 6.4, 6.4
- table design, 5.3, 5.4
- user_source, 6.1
- View menu, 3.2, 3.3, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.6, 4.6, 5.1
- Visual Basic, 3.1, 7.2
- Visual C#, 3.1, 7.2
- Visual Studio .NET 2003, 2.1
W
- warning, 3.7
- WHERE statement clause, 4.4
- window
-
- Add Connection, 5.1, 7.3, 7.5
- Add Method, 6.4, 6.4
- Design, 5.6, 5.6
- Designer, 5.6
- Microsoft Development Environment, 5.6
- New Package, 6.4, 6.4, 6.4
- Output, 6.4, 7.4
- Preview SQL, 5.2, 5.3, 5.3, 5.4, 5.4, 6.4
- Properties, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.6, 5.6, 5.6
- Run Function, 7.6
- Run Procedure, 6.4
- Specify an assembly and library name, 7.5
- Specify copy options, 7.5
- Specify methods and security details, 7.5
- Specify your deployment option, 7.5
- table design, 5.2
- test result, 7.5
- Windows Explorer, 4.1
- Windows forms, 3.4, 3.4, 3.4, 4.3, 4.3, 4.5, 4.6, 4.6, 5.6
- Windows Registry, 8.5, 8.5.1
X
- XE Common Language Runtime agent, 7.1
Z
- zero-based ordinal, 4.3