shoubuliaolebu的专栏

oracle开发 VS INFORMIX开发 实战总结变量定义Oracle:  v_table_name USER_TABLES.table_name%TYPE;Informix:define   v_table_name like systables.tabname;判断某张表是否被锁住Oracle:  select count(*) into v

Oracle数据库字符集问题解析http://www.itpub.net/thread-276524-1-1.html

1.查看所有用户：  select * from dba_users;  select * from all_users;  select * from user_users;2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限)：  select * from dba_sys_privs;  select * from user_sys_privs; 3

转自：http://www.51testing.com/?uid-426602-action-viewspace-itemid-247806查询数据库当前进程的连接数：　　select count(*) from v$process;　　查看数据库当前会话的连接数：　　elect count(*) from v$session;　　查看数据库的并发连接数：　　select

[root@snsgou mysql]# service mysql restartMySQL server PID file could not be found![失败]Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/snsgou.pid).[失败]Google了