Oracle Add self-growing field method steps

Source: Internet
Author: User

First step: Create a self-growing sequence

CREATE SEQUENCE zh_alarm_info_seq--Auto-Grow column

INCREMENT by 1--add a few each time

Start with 1-counting starting from 1

Nomaxvalue--Do not set the maximum value

Nocycle--keep accumulating, not looping

NOCACHE--Do not build buffers 3. Create a trigger:

Step two: Create a trigger for a table with a self-growing field, based on the sequence created in the first step

CREATE OR REPLACE TRIGGER trigger_zh_alarm_info

Before INSERT on Zh_alarm_info

For each row

When (NEW. AID is NULL)

Begin

Select Zh_alarm_info_seq. Nextval into:new. AID from dual;

End

Attachment:

Prerequisites for creating a sequence: the self-growing field must be a large write segment

Sequence Query

Select Zh_alarm_info_seq.nextval from Sys.dual;

Sequence deletion

DROP SEQUENCE Zh_alarm_info_seq

Oracle Add self-growing field method steps

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.