Oracle-PLSQL from installation to training

Contents:

1. Introduction

2. The names of database objects

3. Reserved words and Oracle7 PL / SQL

4. literals, operators and expressions

4.1. Conventions

4.2. The hierarchy of operators

4.3. The syntax of expressions (expr)

4.4. Syntax conditions (condition)

4.5. Logical operators

4.6. Operators used in the SELECT clause

5. Data Types

6. Comments

7. Functions SQL and ORACLE7

7.1. Number functions

7.2. Character features

7.3. Functions with dates and times

7.4. Conversion Functions

7.5. Group Features

7.6. Other Features

8. Formats

8.1. Number formats

8.2. Character formats

8.3. Formats of dates and times

8.4. Prefixes and suffixes are used in formats

9. Pseudo columns and tables

10. Proposals (Team) SQL Oracle7

11. Phrases for proposals (teams) SQL Oracle7

12. Language PL / SQL - SQL Procedural Language Extensions

12.3. Assigning variable values \u200b\u200bfrom database tables

12.3.1. Explicit cursor

12.3.2. Implicit cursor (SQL cursor)

12.4. Operators control the execution of the program

12.5. Error Handling

12.5.1. Built exceptions

12.5.2. Exceptions, user-defined

12.5.3. OTHERS handler

12.6. Transactions

12.7. On the programs of PL / SQL

12.8. Debugging PL / SQL

13. The data dictionary views

14. Virtual data dictionary views

15. System powers Oracle7

16. Authority to objects

17. The basic concepts and parameters used in the directory