Creating Schema

[jarshad]

Hi,

How can I create a schema in a database, Looking for a techincal answer

Thanks


Arshad

[hrishy]

hi

The following statement creates a schema named BLAIR for the user BLAIR, creates the table SOX, creates the view RED_SOX, and grants SELECT privilege on the RED_SOX view to the user WAITES.

CREATE SCHEMA AUTHORIZATION blair
CREATE TABLE sox
(color VARCHAR2(10) PRIMARY KEY, quantity NUMBER)
CREATE VIEW red_sox
AS SELECT color, quantity FROM sox WHERE color = 'RED'
GRANT select ON red_sox TO waites;

do tell me wheather thsi article is technical enough

[jarshad]

Thanks

Hrishi