Oracle Learning Notes-Introduction

Pl/sol (Procedure Language/sol) is a relatively complex programming language for accessing Oracle databases in a variety of environments, integrated with database servers.

Oracle three-tier model

The user interface (for example, the client browser) applies a logical layer (such as an application server) to the database store (Oracle database server)

Pl/sol supports self-supporting data types and user-defined data types

User-defined Types

DECLARE TYPE Myrecord is RECORD (

ID Number (2),

Name varchar (20)

)

Basic structure

DECLARE

-----------

-----------

BEGIN

---------

EXCEPTION

--------------

END

Judging structure

IF------------Then

--------------------

Elsif-------------------Then

ELSE-------------------

END IF

Loop structure

DECLARE-----------

----------------------

BEGIN

LOOP

---------------

EXIT when--------

Or

BEGIN

-----------------

For--------in-------LOOP

---------------------

END LOOP

Cursor definition

DECLARE CURSOR Mycur is selcect------from-------

Fetch data

FETCH Mycur into-----------------

%type

DECLARE FIRSTNAME Students.name%type

By using%type, the FirstName variable has the same structure as the name type of the students table.

In PL/SQL

Set serveroutput [On|off] [size N]

When on, the Dbms_output.put_line () display output can be used in PL/SQL

Oracle Learning Notes-Introduction