//创建一个用户名为c##huqi密码为TIGER的新用户,
create user c##huqi identified by TIGER account unlock;
//给该用户赋权
Grant DBA to c##huqi;
Grant sysoper to c##huqi;
表操作
创建表
create user c##huqi identified by TIGER account unlock;
Grant DBA to c##huqi;
Grant sysoper to c##huqi;
Create table menber (
mid number(5),
name varchar2(50) default '不详',
age number(3),
birthday date default SYSDATE,
note clob -- clob用于存放海量文字
);