did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781590594254

Pro. NET Oracle Programming: From Professional To Expert

by
  • ISBN13:

    9781590594254

  • ISBN10:

    1590594258

  • Format: Paperback
  • Copyright: 2004-11-30
  • Publisher: Springer-Verlag New York Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $59.99 Save up to $1.80
  • Buy New
    $58.19
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-3 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

This book never loses sight of its instructional mission: to effectively utilize the Oracle database from the .NET environment. Though Visual Studio and Oracle form a popular and powerful duo, there is a noticeable lack of written material in this area. The result: projects that often turn out with less-than-optimal solutions, due to lack of "synergy" between the application developer and the database.The primary code in the book will be C#, but the code download will also be available in VB.NET (with an appendix describing terms of use). Hence, this book provides a one-stop reference for any VS.NET programmer using Oracle. The author maintains solid focus on databasesemphasizing the use of specific features from a Visual Studio application. The text also includes crucial aspects of developing Oracle-based applications. Assumably, you are already comfortable with the VS.NET environment, and with the aid of this book, you will come to work effectively with the Oracle database as well.

Table of Contents

About the Author xiii
About the Technical Reviewers xv
Acknowledgments xvii
Introduction xix
Oracle Architecture and Connectivity
1(48)
Exploring the Oracle Server Architecture
2(5)
The Oracle Home
2(2)
The Difference Between a Database and an Instance
4(2)
The Schema
6(1)
The Tablespace
7(1)
The Oracle Network Architecture
7(7)
Oracle Network Components
8(1)
The Listener
9(1)
The tnsnames.ora File
10(1)
The sqlnet.ora File
11(3)
Creating the Standard Configuration
14(19)
Creating a New tnsnames.ora Entry
15(7)
Troubleshooting Common Configuration Errors
22(1)
Creating Users
23(10)
Examining SQL*Plus
33(6)
SQL*Plus Variants
34(1)
Command-Line SQL*Plus
34(3)
The SQL*Plus Profile.Files
37(2)
Selecting a .NET Data Provider
39(1)
Integrating Visual Studio and Oracle
40(5)
Server Explorer Database Connection
40(4)
Types of Oracle Objects Available
44(1)
Creating a Basic Connection
45(3)
The OracleConnection Class
45(1)
The ``Hello, Oracle Here!'' Sanity Check
45(3)
Chapter 1 Wrap-Up
48(1)
Retrieving Data
49(70)
Using the Application Templates
50(3)
The Console Application Template
50(1)
The Windows Forms Application Template
51(2)
Creating the Get Employees Sample
53(2)
Examining the Data Provider Classes
55(22)
The OracleConnection Class
55(4)
The OracleCommand Class
59(7)
The OracleParameter and OracleParameterCollection Classes
66(7)
The OracleDataReader Class
73(4)
Implementing Data Retrieval Techniques
77(40)
Using the TableDirect Method
77(4)
Controlling the Number of Rows Returned
81(5)
Bind Variables and the OracleParameter Class
86(16)
Using the DataReader Properties
102(3)
Using Visual Studio and the Microsoft Data Provider
105(12)
Chapter 2 Wrap-Up
117(2)
Manipulating Data
119(60)
Oracle Architecture Principles Still Apply
119(10)
Exploring Oracle's Locking Mechanism
120(1)
Multiversioning and Read Consistency
121(1)
Locking and MVRC in Action
122(7)
Using the Data Provider Classes
129(17)
The OracleParameter Class
129(4)
The OracleCommand Class
133(1)
The OracleDataAdapter Class
133(7)
The OracleCommandBuilder Class
140(2)
The OracleTransaction Class
142(4)
Implementing DML Operations
146(31)
Using OracleDataAdapter and OracleCommandBuilder
147(5)
Performing Manual DML Operations
152(8)
Using Host Language Array Binding
160(6)
Using the OracleTransaction Class
166(11)
Chapter 3 Wrap-Up
177(2)
Oracle Exception and Error Classes
179(24)
The OracleException Class
179(8)
The DataSource Property
181(1)
The Errors Property
181(1)
The Message Property
181(1)
The Number Property
181(1)
The Procedure Property
181(1)
The Source Property
182(1)
Using the OracleException Class
182(5)
The OracleError Class
187(3)
The OracleError Class Properties
187(1)
Using the OracleError Class
188(2)
The OracleErrorCollection Class
190(4)
An Exception Logging Approach
194(7)
Chapter 4 Wrap-Up
201(2)
Using PL/SQL from .NET
203(44)
Why Use PL/SQL?
204(1)
PL/SQL Packages
205(5)
Creating a Package Specification and Body
205(3)
Querying the user_source View
208(1)
Procedure and Function Overloading
209(1)
Anonymous PL/SQL Blocks
210(2)
Parameters and Return Values
212(12)
The load_table Method
217(1)
The insert_row Code
217(2)
The retrieve_row Code
219(1)
The calculate_points Code
220(1)
The get_team Code
221(1)
Running the Parameters Sample Application
222(2)
The Ref Cursor PL/SQL Data Type
224(1)
Declaring a Ref Cursor Variable in PL/SQL
224(1)
Returning Result Sets from PL/SQL
225(6)
The call_function Code
228(1)
The call_procedure Code
229(1)
Running the RefCursor Sample Application
230(1)
Performing Bulk Operations
231(13)
PL/SQL Associative Arrays
231(2)
Using Bulk Binding
233(1)
The Associative Array Bulk Sample Application
234(3)
The truncate_table Helper Method Code
237(1)
The associative_insert Method Code
238(2)
The associative_select Method Code
240(3)
Running the Associative Sample
243(1)
Chapter 5 Wrap-Up
244(3)
Working with Large Objects
247(38)
Overview of Oracle Large Objects
248(2)
The BFILE Large Object Type
248(1)
The CLOB Large Object Type
249(1)
The NCLOB Large Object Type
249(1)
The BLOB Large Object Type
249(1)
Working with BFILE Objects
250(13)
The OracleBfile Class
250(7)
The BFile Sample
257(6)
Working with CLOB and NCLOB Objects
263(13)
The OracleClob Class
264(4)
The CLOB Sample
268(8)
Working with BLOB Objects
276(7)
The BLOB Sample
276(7)
Chapter 6 Wrap-Up
283(2)
Advanced Connections and Authentication
285(46)
The Default Database Connection
286(4)
Using tnsnames-less Connections
290(6)
Privileged and Non-Privileged Connections
296(5)
The SYSDBA and SYSOPER Privileges
296(5)
Connecting as a Privileged User
301(3)
Connecting via Operating System Authentication
304(6)
Configuring Oracle for Operating System Authentication
305(2)
Testing Operating System Authentication
307(1)
Operating System Authentication in .NET
308(2)
Password Management
310(12)
Changing a Database Password
311(3)
Dealing with Expired Database Passwords
314(5)
Locking Out a Database Account
319(3)
Connection Pooling and Multiplexing
322(8)
Chapter 7 Wrap-Up
330(1)
Performing Common Tasks with Oracle Features
331(34)
Using Anonymous Database Access in a Web Application
331(7)
The ASPNET User
332(2)
Enabling Anonymous Access
334(4)
Creating Paged Results in a Web Application
338(9)
Using a Sequence Object to Generate a Primary Key Value
347(10)
The Increment by Property
348(1)
The Start With Property
348(1)
The Maxvalue/Nomaxvalue Property
348(1)
The Minvalue/Nominvalue Property
348(1)
The Cycle/Nocycle Property
348(1)
The Cache/Nocache Property
349(1)
The Order/Noorder Property
349(1)
Creating Sequences
349(3)
Using Sequences
352(1)
The Sequence Sample Code
353(4)
Creating a Top-N Query
357(6)
Chapter 8 Wrap-Up
363(2)
SQL Tracing
365(28)
Enabling Data Provider Tracing
365(3)
The TraceFileName Registry Key
366(1)
The TraceOption Registry Key
366(1)
The TraceLevel Registry Key
366(1)
Creating a Data Provider Trace File
367(1)
Enabling Basic SQL Tracing
368(7)
Tracing a SQL Statement
371(1)
Formatting the Trace File Using tkprof
372(3)
Enabling Extended SQL Tracing
375(3)
Creating a Trace File from an Application
378(6)
Interpreting the Trace File
384(7)
The Trace File Header
386(1)
The Session Section
386(1)
The First Parsing Section
387(2)
The Second Parsing Section
389(2)
Chapter 9 Wrap-Up
391(2)
APPENDIX Obtaining and Installing the Oracle Software
393(30)
Obtaining the Oracle Software
393(1)
About the Oracle Universal Installer
394(1)
Installing the Oracle Database 10g Software
394(18)
Installing the Oracle Database 10g Client Software
412(7)
Configuring the Registry to Use the Server Network Configuration
419(4)
Index 423

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program