create user user_name identified by XXXXX default tablespace ts_Name quota 5M on ts_name; 创建一个用户就创建了一个和用户名相同的 schema Oracle automatically creates a schema when you create a user 当然也有单独创建 schema 的语句 CREATE SCHEMA AUTHORIZATION schema_name CREATE TABLE new_product (color VARCHAR2(10) PRIMARY KEY, quantity NUMBER) CREATE VIEW new_product_view AS SELECT color, quantity FROM new_product WHERE color = 'RED' GRANT select ON new_product_view TO hr; Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 有帮助文档
default tablespace ts_Name
quota 5M on ts_name;
创建一个用户就创建了一个和用户名相同的 schema
Oracle automatically creates a schema when you create a user 当然也有单独创建 schema 的语句
CREATE SCHEMA AUTHORIZATION schema_name
CREATE TABLE new_product
(color VARCHAR2(10) PRIMARY KEY, quantity NUMBER)
CREATE VIEW new_product_view
AS SELECT color, quantity FROM new_product WHERE color = 'RED'
GRANT select ON new_product_view TO hr; Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02 有帮助文档
的帮助文件,需要例外下载吗?告知下载地质
pangshang ne ?
ma fan !