首页 > 代码库 > 几个oracle 语句

几个oracle 语句

//--------------------------统计表中字段数目--------------------
SELECT COUNT(*) FROM User_Tab_Columns WHERE upper(Table_Name) = upper(‘tbbatchlog‘)

//------------------------创建用户和表空间-----------------------------------------------------

create tablespace banking
logging datafile ‘F:\ORACLE\PRODUCT\10.2.0\ORADATA\JRHB\binking.DBF‘

size 50m

autoextend on

next 50m maxsize 20480m

extent management local; --创建表空间


create user lx IDENTIFIED by sa default tablespace banking; --创建用户并指定默认表空间


grant dba to lx; --用户授权 (dba)

几个oracle 语句