Oracle-002:create Creative Type

--accumulation of SQL for work

There are other types of Oracle. Storage process. Input from the function, and so on.

below to see the creation.

How to use

CREATE OR REPLACE type name as OBJECT
(
Field 1 type,
Field 2 Type,
Field 3 Type
)

Like what

CREATE OR REPLACE TYPE t_obj as OBJECT
(
t_id VARCHAR2 (20),
T_name VARCHAR2 (20)
)

How to use:

Type variable Name: = Type ();

Type variable name. attribute 1= value;

Suppose you want to combine classes into tables

CREATE OR REPLACE type name is TABLE of type name

Like what:

CREATE OR REPLACE TYPE T_out_tab is TABLE of t_obj

Description

The name of the variable of type: = Kind ();

The name of the variable of type. Extend;
The name of the variable of type (0): = this type of individual;

Oracle-002:create Creative Type