![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
iteye_10540
这个作者很懒,什么都没留下…
展开
-
一条Sql语句生成日历
select min(to_char(day, 'yyyymm')) month, min(decode(weekday, 1, day)) "星期日" min(decode(weekday, 2, day)) "星期一", min(decode(weekday, 3, day)) "星期二", min(decode(weekday, 4, day)) "星...2010-03-02 16:47:03 · 211 阅读 · 0 评论 -
Oracle数据库中rowid与rownum的区别
在查询中,我们可以注意到,类似于“select xx from table where rownum < n”(n>1)这样的查询是有正确含义的,而“select xx from table where rownum = n”这样的查询只在n=1的时候成立,“select xx from table where rownum > n”(n>1)这样的查询只能...原创 2010-03-03 12:46:05 · 116 阅读 · 0 评论 -
Oracle中重新设置SYS用户密码
忘记管理员密码,于是上网找到一个重新设置sys用户密码的语句,嘿嘿,这样就不怕啦。 sqlplus /nolog conn /as sysdba alter user sys identified by sysadmin ...原创 2010-07-26 13:03:12 · 152 阅读 · 0 评论 -
误删表空间文件,造成“ORA-01033: ORACLE 正在初始化或关闭”
C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期三 5月 12 09:05:56 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL>connect sys/sy...原创 2012-03-07 20:39:22 · 153 阅读 · 0 评论