ual;

le

--

啊

57.uid

返回标识当前用的唯一整数

sql>showuser

user为”gao”

sql>selectusername,user_idfromdba_userswhereuser_id=uid;

usernameuser_id

---------------------------------------

gao25

58.user

返回当前用的名字

sql>selectuserfromdual;

user

------------------------------

gao

59.userevn

返回当前用环境的信息,opt可以是:

entryid,sessionid,terminal,isdbablenguage,client_infong,vsize

isdba查看当前用是否是dba如果是则返回true

sql>selectuserenv(‘isdba‘)fromdual;

useren

------

false

sql>selectuserenv(‘isdba‘)fromdual;

useren

------

true

session

返回会话标志

sql>selectuserenv(‘sessionid‘)fromdual;

userenv(‘sessionid‘)

--------------------

152

entryid

返回会话人标志

sql>selectuserenv(‘entryid‘)fromdual;

userenv(‘entryid‘)

------------------

0

instance

返回当前instance的标志

sql>selectuserenv(‘instance‘)fromdual;

userenv(‘instance‘)

-------------------

1

nguage

返回当前环境变量

sql>selectuserenv(nguage‘)fromdual;

userenv(nguage‘)

----------------------------------------------------

simplifiedchinese_china.zhs16gbk

ng

返回当前环境的语言的缩写

sql>selectuserenv(ng‘)fromdual;

userenv(ng‘)

----------------------------------------------------

zhs

terminal

返回用的终端或机的标志

sql>selectuserenv(‘terminal‘)fromdual;

userenv(‘termina

----------------

gao

vsize(x)

返回x的大小(字节)数 [page]

sql>selectvsize(user),userfromdual;