创建表oracle
代码示例
创建表oracle
CREATE TABLE ot.persons(
person_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
first_name VARCHAR2(50) NOT NULL,
last_name VARCHAR2(50) NOT NULL,
PRIMARY KEY(person_id)
);oracle sql创建表
/*Deleting whole table with data */
DROP TABLE vehicles;
DROP TABLE owners;
/*First create only this table */
CREATE TABLE owners (
owner_id NUMBER,
first_name VARCHAR2(50 CHAR) NOT NULL,
CONSTRAINT owners_pk PRIMARY KEY(owner_id)
);
/* One owner got many vehicles, one to many relation
or one vehicle got many owners */
CREATE TABLE vehicles (
vehicle_id NUMBER,
vehicle_name VARCHAR2(50 CHAR) NOT NULL,
/* CONSTRAINT vehicle_pk PRIMARY KEY(vehicle_id) --If we had made PRIMARY KEY here it will be one to one relation */
CONSTRAINT vehicle_owner_fk FOREIGN KEY(vehicle_id) REFERENCES owners(owner_id) ON DELETE SET NULL
);
INSERT IGNORE INTO owners VALUES(1, 'Abbi');
INSERT IGNORE INTO owners VALUES(2, 'Beatrix');
INSERT IGNORE INTO owners VALUES(3, 'Caila');
INSERT IGNORE INTO owners VALUES(4, 'Dea');
INSERT IGNORE INTO owners VALUES(5, 'Elise');
INSERT IGNORE INTO vehicles VALUES(1, 'car');
INSERT IGNORE INTO vehicles VALUES(2, 'motorcycle');
INSERT IGNORE INTO vehicles VALUES(3, 'airplane1');
INSERT IGNORE INTO vehicles VALUES(4, 'airplane1');
INSERT IGNORE INTO vehicles VALUES(4, 'steamer');
INSERT IGNORE INTO vehicles VALUES(4, 'submarine');
COMMIT;
DELETE FROM projects WHERE vehicle_id = 4 AND vehicle_name = 'submarine';
/*
Sometimes Oracle SQL Dev don't like this sign ';',
Primary Key is always NOT NULL UNIQUE,
single PK PRIMARY KEY(user_id), allowed combination:
(1,1) for example (user_id, project_id)
(2,1)
(3,1)
(4,2)
*/
-- one line comment
类似页面
带有示例的类似页面
其他语言
此页面有其他语言版本
empty row
Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................
受欢迎的此类别
标籤的相关热门网页
empty row