Oracle建表命令

参考：http://blog.itpub.net/26110315/viewspace-736454/

 

SQL>:create schema authorization root

          create table "table1"(name varchar(55), mobile varchar(55))

          create view "table1_view" as select name, mobile from "table1"

          grant select on "table1_view" to root;