![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle基础
leegaoge
这个作者很懒,什么都没留下…
展开
-
转载一篇
sure you are all familiar with this situation:SQL> alter system kill session '152,33';alter system kill session '152,33'*ERROR at line 1:ORA-00031: session marked for killThe session tr...2010-03-30 12:04:40 · 116 阅读 · 0 评论 -
sql小结(1)
//在crud中调用函数 select Func_getUTCDate() from dual;-----------------------------------------------------------------------------...原创 2009-12-31 18:48:11 · 67 阅读 · 0 评论 -
sql基础(3)
//查看当前用户的缺省表空间SQL>select username,default_tablespace from user_users;//查看当前用户的角色SQL>select * from user_role_privs;//查看当前用户的系统权限和表级权限select * from user_sys_privs;select * from use...原创 2010-02-08 14:17:21 · 92 阅读 · 0 评论 -
sql(4)
在含有子查询的SQL语句中,要特别注意减少对表的查询.Update 多个Column 例子: 低效: UPDATE EMP SET EMP_CAT = (SELECT MAX(CATEGORY) FROM EMP_CATEGORIES), SAL_RANGE = (SELECT MAX(SAL_RA...原创 2010-02-08 14:35:32 · 72 阅读 · 0 评论