ORACLE PL/SQL Programming Performance Objectives
Short summary:
ORACLE: PL/SQL Programming. Performance Objectives. SYS-ED with Oracle.How to branch to/from exceptions. How to add fields containing error information. Processing after an exception ...
Long summary:
ORACLE: PL/SQL Programming Performance Objectives Getting Started You will learn: How to invoke and run SQL using the SQL/PLUS development tool. Capabilities and limitations of PL/SQL. Chapter 2: Fundamentals You will learn: Rules and syntax of PL/SQL. Block structure of the code. How to define constants and variables and understand the scope of variables. Creating cursors and loop through the recordset. Techniques for enhancing and simplifying declarations. Coding techniques for interactive control. Benefits of using packages. Coding and designing programs using subprograms. Declaring and using collections. Handling and processing error. Chapter 3: Architecture You will learn: PL/SQL interaction with Oracle. How triggers are used in databases. Integration with SQL. OOPs features in PL/SQL. Chapter 4: Programming Elements You will learn: Basic elements in PL/SQL. Variable naming convention and rules. Literals. Different data types and their associated usage. Languages operators and clauses. Chapter 5: Flow of Control You will learn: Coding techniques using IF, LOOP and WHILE statements. Flow of control statements. Optimization techniques with flow of control statements. ORACLE: PL/SQL Programming Performance Objectives Page ii Chapter 6: Interaction with Oracle You will learn: How to use PL/SQL for interaction with an Oracle database. Concepts of a transaction and how to code and control transactions. Manipulation of cursors. ROWID and ROWNUM. Chapter 7: Error Handling You will learn: Error handling philosophy utilized in PL/SQL. Declare exception and using predefined exceptions. How to test error conditions. How to branch to/from exceptions. How to add fields containing error information. Processing after an exception. Chapter 8: Cursors You will learn: Cursor declaration. Open, fetch, and close. Updating through cursors. Looping through cursors. Performance issues associated with cursors. When to use cursors. Coding cursor variables. Chapter 9: Subprograms You will learn: Coding subprograms. Passing parameters. Differences between actual and formal parameters. Coding and understanding the parameter modes. Overloading techniques. ORACLE: PL/SQL Programming Performance Objectives SYS-ED ® \COMPUTER EDUCATION TECHNIQUES, INC. (ORACLE: PL/SQL 0.7) Perf Obj: Page iii Chapter 10: Collections and Records You will learn: How to code programs using tables. Advantages of nested tables. The differences and advantages of Varrays versus nested tables. Coding techniques using collections. Declaring and using records for simplifying the code. Chapter 11: Transaction Processing You will learn: Size and scope of a transaction. Coding and testing the various commands associated with committing and rolling back a transaction. Locking a table ...
Source: www.sysed.com
Search Terms:
Related
ORACLE PL/SQL Programming Performance Objectives, ORACLE: PL/SQL Programming. Performance
Objectives. SYS-ED with Oracle.How to
branch to/from exceptions. How to add
fields containing error information.
Processing after an exception ...,
more
Protecting Oracle Databases, Securing your database involves not only
stablishing strong password policy, but
also establishing adequate access
controls. In this paper, we will cover
various ways databases. programming
guideline for web programmers that
includes emphasis on using parameterized
queries ...,
more
Object Database Designer - Oracle 8 Design & Generation Technology, Designer is the natural companion for
anybody designing and building Oracle 8.
systems. mechanism for C++ programs to
access Oracle 8 seamlessly. Using ...,
more
