??xml version="1.0" encoding="utf-8" standalone="yes"?>97久久人人超碰,日韩国产一区二区,麻豆一区二区99久久久久http://www.aygfsteel.com/sanwish/by sanwishzh-cnSun, 06 Jul 2025 14:38:48 GMTSun, 06 Jul 2025 14:38:48 GMT60windows2003server下安装oracle8.1.7http://www.aygfsteel.com/sanwish/archive/2009/02/10/254087.htmlsanwishsanwishTue, 10 Feb 2009 07:00:00 GMThttp://www.aygfsteel.com/sanwish/archive/2009/02/10/254087.htmlhttp://www.aygfsteel.com/sanwish/comments/254087.htmlhttp://www.aygfsteel.com/sanwish/archive/2009/02/10/254087.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/254087.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/254087.html有一个问题先提出来,安装oracle必须直接在系l上安装Q不能通过q程桌面或者终端服务安装,否则会报“ORA-12560: TNS: 协议适配器错误”。还有一点,oracle8.1.7有一个补丁程序PATCH_SET_FOR_ORACEL_DATA_8174_WINNT.zipQ以前从来没有见q,q次是从教育|里׃一天时间下载下来的Q不知道是不是在win2003上安装必ȝQ下周即可见分校晓)?/p>

1、如果你的oracle8.1.7是原始版的,?br />/stage/Components/oracle.swd.jre/
1.1.7.30/1/DataFiles/Expanded/jre/win32/bin下的symcjit.dll文gQ改名或者直接删除?br />/stage/Components/oracle.omb.jdk/1.1.8/1/DataFiles/Expanded/jdk118_nt/bin路径下的symcjit.dll文g做同样处理?/p>

2、如果遇到点击setup.exe无反应,在install目录下打开文g’oraparam.ini’把参数 JRE_MEMORY_OPTIONS改ؓ

RE_MEMORY_OPTIONS = -nojit -ms16m -mx32m 卛_?br />
3、执行本地硬盘install\win32\setup.exe目录下的Setup.exe文g。此时调用的是修改过的参数文件oraparam.ini。?br /> 
4、安装时选择自定义模式,q且不创建数据库?
   具体参照<windows+oracle8 install manual>



sanwish 2009-02-10 15:00 发表评论
]]>
查看oracle某个表的所有字D名http://www.aygfsteel.com/sanwish/archive/2008/12/03/244074.htmlsanwishsanwishWed, 03 Dec 2008 01:48:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/12/03/244074.htmlhttp://www.aygfsteel.com/sanwish/comments/244074.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/12/03/244074.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/244074.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/244074.htmlall_tab_columns   where   table_name='table1';
sql2Qselect   column_name   from   user_tab_columns   where   table_name='table1';


我在q行sql1的时候碰刎ͼ如果数据库中有相同用L话,会检索出重复的字D名?br />后来把用Ldba权限L了就好了?br />revoke dba from user1;

q行sql2Q虽然不出现重复的,但是客户说最l工E所用的DB用户和表的所有者不是一个,所以不能用user_table_columns?br />oracle知识太缺乏,不明白客戯的意?br />
关于sql1重复的问题,q是不清楚,具体的参照权限应该怎么取消Q取消dba太大了吧?img src ="http://www.aygfsteel.com/sanwish/aggbug/244074.html" width = "1" height = "1" />

sanwish 2008-12-03 09:48 发表评论
]]>
Q{Q用 ANY、SOME ?ALL 修改的比较运符http://www.aygfsteel.com/sanwish/archive/2008/11/10/239604.htmlsanwishsanwishMon, 10 Nov 2008 02:02:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239604.htmlhttp://www.aygfsteel.com/sanwish/comments/239604.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239604.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239604.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239604.html阅读全文

sanwish 2008-11-10 10:02 发表评论
]]>
Q{QSQL中decode函数的用?/title><link>http://www.aygfsteel.com/sanwish/archive/2008/11/10/239603.html</link><dc:creator>sanwish</dc:creator><author>sanwish</author><pubDate>Mon, 10 Nov 2008 02:00:00 GMT</pubDate><guid>http://www.aygfsteel.com/sanwish/archive/2008/11/10/239603.html</guid><wfw:comment>http://www.aygfsteel.com/sanwish/comments/239603.html</wfw:comment><comments>http://www.aygfsteel.com/sanwish/archive/2008/11/10/239603.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/sanwish/comments/commentRss/239603.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/sanwish/services/trackbacks/239603.html</trackback:ping><description><![CDATA[     摘要:   <a href='http://www.aygfsteel.com/sanwish/archive/2008/11/10/239603.html'>阅读全文</a><img src ="http://www.aygfsteel.com/sanwish/aggbug/239603.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/sanwish/" target="_blank">sanwish</a> 2008-11-10 10:00 <a href="http://www.aygfsteel.com/sanwish/archive/2008/11/10/239603.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Q{QOracle PL/SQL语言初教程之操作和控制语言http://www.aygfsteel.com/sanwish/archive/2008/11/10/239601.htmlsanwishsanwishMon, 10 Nov 2008 01:56:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239601.htmlhttp://www.aygfsteel.com/sanwish/comments/239601.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239601.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239601.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239601.html阅读全文

sanwish 2008-11-10 09:56 发表评论
]]>
(转)ORACLE 中ROWNUM用法ȝ!http://www.aygfsteel.com/sanwish/archive/2008/11/10/239600.htmlsanwishsanwishMon, 10 Nov 2008 01:55:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239600.htmlhttp://www.aygfsteel.com/sanwish/comments/239600.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/10/239600.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239600.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239600.html 对于 Oracle ?rownum 问题Q很多资料都说不支持>,>=,=,between...andQ只能用以上W号(<?lt;=?=)Qƈ非说?gt;,>=,=,between..and 时会提示SQL语法错误Q而是l常是查不出一条记录来Q还会出C乎是莫名其妙的结果来Q其实您只要理解好了q个 rownum 伪列的意义就不应该感到惊奇,同样是伪列,rownum ?rowid 可有些不一P下面以例子说?br />
假设某个?t1(c1) ?20 条记?br />
如果?select rownum,c1 from t1 where rownum < 10, 只要是用于P查出来的l果很容易地与一般理解在概念上能达成一_应该不会有Q何疑问的?br />
可如果用 select rownum,c1 from t1 where rownum > 10 (如果写下q样的查询语句,q时候在您的头脑中应该是惛_到表中后?0条记?Q你׃发现Q显C出来的l果要让您失望了Q也许您q会怀疑是不谁删了一些记录,然后查看记录敎ͼ仍然?20 条啊Q那问题是出在哪呢?

先好好理?rownum 的意义吧。因为ROWNUM是对l果集加的一个伪列,卛_查到l果集之后再加上ȝ一个列 (Q先要有l果?。简单的?rownum 是对W合条gl果的序列号。它L?开始排L。所以你选出的结果不可能没有1Q而有其他大于1的倹{所以您没办法期望得C面的l果集:

11 aaaaaaaa
12 bbbbbbb
13 ccccccc
.................

rownum >10 没有记录Q因为第一条不满L的话Q第二条的ROWNUM又成?Q所以永q没有满x件的记录。或者可以这L解:

ROWNUM 是一个序列,是oracle数据库从数据文g或缓冲区中读取数据的序。它取得W一条记录则rownumgؓ1Q第二条?Q依ơ类推。如果你?gt;,>=,=,between...andq些条gQ因Z~冲区或数据文g中得到的W一条记录的rownum?Q则被删除,接着取下条,可是它的rownumq是1Q又被删除,依次cLQ便没有了数据?br />
有了以上从不同方面徏立v来的?rownum 的概念,那我们可以来认识使用 rownum 的几U现?br />
1. select rownum,c1 from t1 where rownum != 10 Z是返回前9条数据呢Q它?select rownum,c1 from tablename where rownum < 10 q回的结果集是一L呢?
因ؓ是在查询到结果集后,昄完第 9 条记录后Q之后的记录也都?!= 10,或?>=10,所以只昄前面9条记录。也可以q样理解Qrownum ?后的记录?rownum?0Q因条g?!=10Q所以去掉,其后记录补上Qrownum又是10Q也LQ如果下M只会显C前?条记录了

2. Z?rownum >1 时查不到一条记录,?rownum >0 ?rownum >=1 却LC所以的记录
因ؓ rownum 是在查询到的l果集后加上ȝQ它L?开?br />
3. Z?between 1 and 10 或?between 0 and 10 能查到结果,而用 between 2 and 10 却得不到l果
原因同上一P因ؓ rownum L?1 开?br />
从上可以看出QQ何时候想?rownum = 1 q条记录抛弃是不对的Q它在结果集中是不可或缺的,了rownum=1 像IZ楼阁一般不能存在,所以你?rownum 条g要包含到 1

但如果就是想要用 rownum > 10 q种条g的话话就要用嵌套语句,?rownum 先生成,然后对他q行查询?br />select *
from (selet rownum as rnQt1.* from a where ...)
where rn >10

一般代码中对结果集q行分页是q么q的?br />
另外Qrowid ?rownum 虽都被称Z列,但它们的存在方式是不一LQrowid 可以说是物理存在的,表示记录在表I间中的唯一位置IDQ在DB中唯一。只要记录没被搬动过Qrowid是不变的。rowid 相对于表来说又像表中的一般列Q所以以 rowid 为条件就不会?rownum那些情况发生?br />另外q要注意Qrownum不能以Q何基表的名称作ؓ前缀?/font>

sanwish 2008-11-10 09:55 发表评论
]]>
日文字符~码http://www.aygfsteel.com/sanwish/archive/2008/11/07/239240.htmlsanwishsanwishFri, 07 Nov 2008 05:29:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239240.htmlhttp://www.aygfsteel.com/sanwish/comments/239240.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239240.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239240.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239240.html 半角数字
unicode0123456789abcdef
0x300123456789:;<=>?


全角数字
unicode0123456789abcdef
0xff10Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>


半角英字
unicode0123456789abcdef
0x40@ABCDEFGHIJKLMNO
0x50PQRSTUVWXYZ[\]^_
0x60`abcdefghijklmno
0x70pqrstuvwxyz{|}~


全角英字
unicode0123456789abcdef
0xff20Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff30Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff40?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0xff50?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?


がӂがな
unicode0123456789abcdef
0x3050??/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x3050?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x3060?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x3070?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x3080?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x3090?/td>?/td>?/td>?/td>?/td>???????/td>?/td>?/td>?/td>?


全角カタカナ
unicode0123456789abcdef
0x3050??/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x30b0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x30c0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x30d0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x30e0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0x30f0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?????/td>?/td>?/td>?/td>?


半角カタカナ
unicode0123456789abcdef
0xff60??/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0xff70?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0xff80?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0xff90?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>


半角a号
unicode0123456789abcdef
0x20 !"#$%&'()*+,-./
0x300123456789:;<=>?
0x40@ABCDEFGHIJKLMNO
0x50PQRSTUVWXYZ[\]^_
0x60`abcdefghijklmno
0x70pqrstuvwxyz{|}~
?/td>
0xff60??/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>


全角a号
unicode0123456789abcdef
0x2010?/td>?????/td>???/td>?/td>???/td>?/td>??
?/td>
0x3000 ?/td>?/td>?/td>??/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
?/td>
0x30f0?/td>?/td>?/td>?/td>?/td>?/td>?/td>?????/td>?/td>?/td>?/td>?
?/td>
0xff00? Q?/td>?Q?/td>Q?/td>Q?/td>Q?/td>?Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff10Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff20Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff30Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>Q?/td>
0xff40?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>
0xff50?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?/td>?
?/td>
0xffe0K?/td>K?/td>K?/td>K?/td>?K?/td>??????????



sanwish 2008-11-07 13:29 发表评论
]]>
字符~码问题http://www.aygfsteel.com/sanwish/archive/2008/11/07/239239.htmlsanwishsanwishFri, 07 Nov 2008 05:27:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239239.htmlhttp://www.aygfsteel.com/sanwish/comments/239239.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239239.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239239.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239239.html阅读全文

sanwish 2008-11-07 13:27 发表评论
]]>
pageEncoding和contentType的区?/title><link>http://www.aygfsteel.com/sanwish/archive/2008/11/07/239236.html</link><dc:creator>sanwish</dc:creator><author>sanwish</author><pubDate>Fri, 07 Nov 2008 05:20:00 GMT</pubDate><guid>http://www.aygfsteel.com/sanwish/archive/2008/11/07/239236.html</guid><wfw:comment>http://www.aygfsteel.com/sanwish/comments/239236.html</wfw:comment><comments>http://www.aygfsteel.com/sanwish/archive/2008/11/07/239236.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/sanwish/comments/commentRss/239236.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/sanwish/services/trackbacks/239236.html</trackback:ping><description><![CDATA[     摘要:   <a href='http://www.aygfsteel.com/sanwish/archive/2008/11/07/239236.html'>阅读全文</a><img src ="http://www.aygfsteel.com/sanwish/aggbug/239236.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/sanwish/" target="_blank">sanwish</a> 2008-11-07 13:20 <a href="http://www.aygfsteel.com/sanwish/archive/2008/11/07/239236.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Q{Qjsp中的includeq问题http://www.aygfsteel.com/sanwish/archive/2008/11/07/239218.htmlsanwishsanwishFri, 07 Nov 2008 03:37:00 GMThttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239218.htmlhttp://www.aygfsteel.com/sanwish/comments/239218.htmlhttp://www.aygfsteel.com/sanwish/archive/2008/11/07/239218.html#Feedback0http://www.aygfsteel.com/sanwish/comments/commentRss/239218.htmlhttp://www.aygfsteel.com/sanwish/services/trackbacks/239218.html阅读全文

sanwish 2008-11-07 11:37 发表评论
]]>
վ֩ģ壺 ±| | ƽ| | | | | Զ| | ƽ| | ֬| | ״| | | | | IJ| Դ| | ī񹤿| | | | | կ| | ī| ͷ| ʱ| ̫| Ӳ| û| °Ͷ| ޽| ׺| ɽ| | | ֿ|