ORACLE中,大括号,方括号含义。
命令含义什么?大括号是必填,方括号可添可不填么?比如创建用户CREATEUSERuser_nameIDENTIFIED{BYpassword|EXTERNALLY|GLO...
命令含义什么?大括号是必填,方括号可添可不填么?比如创建用户
CREATE USER user_name
IDENTIFIED {BY password|EXTERNALLY|GLOBALLY AS external_name}
[{DEFAULT TABLESPACE default_tablespace|TEMPORARY TABLESPACE temporary_tablespace|QUOTA{quota[K|M]|UNLIMITED}ON tablespace|PROFILE profile|PASSWORD EXPIRE|ACCOUNT{LOCK|UNLOCK}
}
]; 展开
CREATE USER user_name
IDENTIFIED {BY password|EXTERNALLY|GLOBALLY AS external_name}
[{DEFAULT TABLESPACE default_tablespace|TEMPORARY TABLESPACE temporary_tablespace|QUOTA{quota[K|M]|UNLIMITED}ON tablespace|PROFILE profile|PASSWORD EXPIRE|ACCOUNT{LOCK|UNLOCK}
}
]; 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询