?? oracle.sql
字號(hào):
CREATE TABLESPACE message
DATAFILE '/opt/oracle/oradata/surecomp/message01.dbf' size 200M
EXTENT MANAGEMENT local;
CREATE USER message IDENTIFIED BY message
DEFAULT TABLESPACE message;
GRANT connect, resource TO message;
CREATE TABLE userinfo (
id VARCHAR2(32) NOT NULL,
name VARCHAR2(32) NOT NULL,
password VARCHAR2(32) NOT NULL,
CONSTRAINT userinfo_pk PRIMARY KEY (id),
CONSTRAINT userinfo_unique_name UNIQUE ( name )
);
CREATE TABLE message (
id VARCHAR2(32) NOT NULL,
title VARCHAR2(32) NOT NULL,
content VARCHAR2(2000),
user_id VARCHAR2(32),
CONSTRAINT message_pk PRIMARY KEY (id),
CONSTRAINT message_user FOREIGN KEY (user_id) REFERENCES userinfo(id)
);
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -