Intelligentedu �ł��悭�V�������R�ȃR���s���[�^����P���̌l�w������

�^�C�g����t������Oracle�����2���Ԃ�dotNEt�̃f�[�^�x�[�X�̃R�[�X�͂����ɂ��� Oracle�� �f�[�^�x�[�X2��+ .NET�̊J���҂̃K�C�h11g���1 (11.1). �����.NET�̂��߂�Oracle�f�[�^�񋟎҂���ю��o�X�^�W�I�̂��߂� Oracle�̊J���җp��̎�v���_���܂�.NET�t���[�����[�N���t���Ă��� Oracle�̃f�[�^�x�[�X���g�p���āA�n�܂�̂�������B ������g�p����Oracle .NET���i ����у\�t�g�E�F�A���g�p���Ċ�{�I�ȓK�p����t���A�`�����A������@���A �w�ԁB �܂�PL-SQL�����.NET�̕ۑ����ꂽ�菇 ���쐬���g�p������@���w�ԁB �܂��ژ^�̉��� �‚Ȃ���֘A������_�����Ȃ����B ���̃K�C�h�� �܂����p�ł��� pdf�� �t�H�[�}�b�g.


Oracle��2���̃f�[�^�x�[�X�����.NET�̊J���҂̃R�[�X �̂��߂̖ژ^:

1�‚� ����

• ���� �K�C�h�ɂ‚���
• What is the Microsoft .NET Framework
• .NET �̂��߂�Oracle�f�[�^�񋟎҂̊T��
• ���o �X�^�W�I�̂��߂�Oracle�̊J���җp��̊T��
• .NET�� �ۑ����ꂽ�菇�̊T��
• Oracle�� �񋟎҂̊T�ς̂��߂� ASP.NET

2�‚� ��t����.NET�v���_�N�g

• �K�v�Ƃ��鉽��
  • Oracle�� �f�[�^�x�[�X
  • �T���v�� �f�[�^
  • Oracle�� �f�[�^�E�A�N�Z�X�̕��i
  • .NET �̂��߂�Oracle�̃f�[�^�x�[�X����
  • ���o �X�^�W�I2008�N
• .NET �v���_�N�g����t���邱��
• �Ԃ��`�����ĕʖ��Őڑ����Ȃ���

3 �ȒP��.NET�̓K�p��ODP .NET���g�p���đ���

• �V�����v���W�F�N�g�̍쐬
• �Q�Ƃ������邱��
• Namespace�� �w�߂������邱��
• ���[�U�E�C���^�t�F�[�X�̐݌v
• Writing the Connection Code
• Compiling and Running the Application
• Error Handling
  • Using Try-Catch-Finally Block Structure
  • Handling General Errors
  • Handling Common Oracle Errors

4 Retrieving and Updating with Oracle Data Provider for .NET

• Using the Command Object
• Retrieving Data: a Simple Query
• Retrieving Data: Bind Variables
• Retrieving Data: Multiple Values
• Using the DataSet Class with Oracle Data Provider for .NET
• Enabling Updates to the Database
• Inserting, Deleting, and Updating Data

5 Using Oracle Developer Tools for Visual Studio

• Using Oracle Developer Tools
• Connecting to the Oracle Database
• Creating a Table and Its Columns
• Creating a Table Index
• Adding Table Constraints
• Adding Data to a Table
• Generating Code Automatically to Display and Update Data

6 Using PL/SQL Stored Procedures and REF CURSORs

• Introduction to PL/SQL Stored Procedures
• Introduction to PL/SQL Packages and Package Bodies
• Introduction to REF CURSORs
• Creating a PL/SQL Stored Procedure that Uses REF CURSORs
• Modifying an ODP .NET Application to Run Stored Procedures
• Running a PL/SQL Stored Procedure Using an ODP .NET Application

7 Developing and Deploying .NET Stored Procedures

• Overview of .NET Stored Procedures
• Starting the Common Language Runtime Service
• Creating a Connection as SYSDBA
• Creating an Oracle Project
• Creating .NET Stored Functions and Procedures
• Deploying .NET Stored Functions and Procedures
• Running .NET Stored Functions and Procedures
• Running .NET Stored Procedure in a Query Window

8 Including Globalization Support

• Introduction to Global Applications
• Developing Global Applications with the .NET Framework
• Presenting Data in the Correct User Local Convention
  • Connecting to SQL*Plus
  • Using Oracle Date Formats
  • Using Oracle Number Formats
  • Using Oracle Linguistic Sorts
  • Oracle Error Messages
• Synchronizing the .NET and Oracle Database Locale Environments
• Client Globalization Support in Oracle Data Provider for .NET
  • Client Globalization Settings
  • Using Session Globalization Settings
  • Thread-Based Globalization Settings

Appendix A Starting and Stopping an Oracle Database Instance
Appendix B Copying a Form Index


Related Training and Help Documents from Oracle:

• Oracle Data Provider for .NET Developer's Guide
• Oracle Database Extensions for .NET Developer's Guide
• Oracle Database 2 Day DBA
• Oracle Database 2 Day Developer's Guide

Popularity: 10% [?]

Related Posts:

Developing Oracle Database Applications with Visual Studio and .NET

Tutorials for .Net, ASP and Windows Web Developers

Free Book on ASP.NET 2.0

Free Microsoft ASP.NET 2.0 Webcast Series

Enterprise Library for .NET Framework 2.0

Tags for this post>> Oracle | SQL