Привет, есть вопрос, мне нужно этот код сделать для Оракла, поскольку оракла нету, вопрошаю ваше мнение:
Я сделал так, потестить негде, очень нужна помощь, спасибо!
-- Sybase:
create table CustPref
(
id integer DEFAULT AUTOINCREMENT,
product varchar(255) not null,
name varchar(255) not null,
value varchar(255) not null,
customer varchar(255) not null,
primary key clustered (id)
)
create nonclustered index bk_index on CustPref (product, name, customer)
create table CustPref
(
id integer DEFAULT AUTOINCREMENT,
product varchar(255) not null,
name varchar(255) not null,
value varchar(255) not null,
customer varchar(255) not null,
primary key clustered (id)
)
create nonclustered index bk_index on CustPref (product, name, customer)
-- Oracle:
CREATE TABLE CustPref (
id INT PRIMARY KEY,
product VARCHAR2(255) not null,
name VARCHAR2(255) not null,
value VARCHAR2(255) not null,
customer VARCHAR2(255) not null
);
CREATE INDEX bk_index ON CustPref (product, name, customer);
CREATE SEQUENCE custpref_sequence START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER custpref_trigger
BEFORE INSERT
ON CustPref
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT custpref_sequence.nextval INTO :NEW.ID FROM dual;
END;
/
CREATE TABLE CustPref (
id INT PRIMARY KEY,
product VARCHAR2(255) not null,
name VARCHAR2(255) not null,
value VARCHAR2(255) not null,
customer VARCHAR2(255) not null
);
CREATE INDEX bk_index ON CustPref (product, name, customer);
CREATE SEQUENCE custpref_sequence START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER custpref_trigger
BEFORE INSERT
ON CustPref
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT custpref_sequence.nextval INTO :NEW.ID FROM dual;
END;
/
Comment