Tag: plsql

How to create the correct trigger instead of insert or update? ORACLE. Trigger. pl/sql

The tables look like this. CREATE TABLE Users(id_user INTEGER GENERATED ALWAYS AS IDENTITY(START with 1 INCREMENT by 1 NOCACHE) PRIMARY KEY, surname VARCHAR2(30) NOT NULL, name VARCHAR2(30) NOT NULL, patronymic VARCHAR2(30) NULL, tel_no VARCHAR2(17) NOT NULL, CONSTRAINT ch_telno_users CHECK(REGEXP_LIKE(tel_no, ‘^\+375\(\d{2}\)\d{3}-\d{2}-\d{2}$’)), CONSTRAINT uni_telno_users UNIQUE(tel_no) ); CREATE TABLE Software(id_sw INTEGER GENERATED ALWAYS AS IDENTITY(START with 1 INCREMENT […]

Back To Top