Oracle-002:create Creative Type

Source: Internet
Author: User

--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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.