JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » Oracle  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to topicthreaded modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 [分享] 我的 Oracle9i: SQL 筆記 [精華]
error21h

吃飽睡,睡飽吃



發文: 60
積分: 2
於 2004-12-28 09:34 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
最近常看到有些人在問Oracle 的SQL語法...

這是我之前學習 Oracle SQL 時,所留下來的筆記....

內容主要從 Oracle Student Guide 及 Oracle 9i
1Z0-007 認證指南中 ,整理出來的...

希望對各位有所幫助...Smile~

Introduction to Oracle9i SQL.rar (555.1k)


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
anthonychen

外線交給我

版主

發文: 2033
積分: 8
於 2004-12-28 10:47 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
很不錯呢,內容豐富喔 Wink

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
tingnet

Java+Oracle=Bible



發文: 303
積分: 5
於 2004-12-28 11:36 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
辛苦了,整理的不錯,感謝你的分享 Smile

reply to postreply to post
我知道我的堅持是什麼!!
學無止盡呀!!!
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
reggie

Java Life



發文: 238
積分: 1
於 2004-12-28 12:20 user profilesend a private message to usersend email to reggiereply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
收下了...感謝您的整理!!前人種樹、後人乘涼啊....^_^

reply to postreply to post
愈來愈喜歡吃蘋果了
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
vampire





發文: 14
積分: 0
於 2004-12-29 12:00 user profilesend a private message to usersend email to vampirereply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感恩蛤~
即然你懂Oracle
是否能借問一下,我最近在複習之前學過的Oracle
我灌的是Oracle9.2中文版(我的OS是中文版的,所以在灌Oracle時,安裝光碟會自己去抓適合的語言)
當我要 INSERT 一筆資料進去資枓庫
用 TO_DATE('01-JAN-04', 'DD-MON-YY'); 會出現錯誤訊息
用 TO_DATE('01-1月-04', 'DD-MON-YY'); 就可以INSERT成功
我的問題是 'MON'在中文版來講是指 1月,2月.....而不是JAN,FEB..嗎??
那MONTH咧??
假設我INSERT 01-01-05 這個日期進資料庫裡,
那真正存入資料庫裡的資料是什麼?? 01-1月-05 or 01-JAN-05 or其它型式??


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:vampire]
anthonychen

外線交給我

版主

發文: 2033
積分: 8
於 2004-12-29 13:56 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
vampire wrote:
感恩蛤~
即然你懂Oracle
是否能借問一下,我最近在複習之前學過的Oracle
.....

本串討論本意是 error21h 用來分享心得的,如要發問,請另行 post 文發問,謝謝

本篇將於一天內刪除,請盡快重新發問


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
j9d9





發文: 56
積分: 1
於 2005-01-03 14:04 user profilesend a private message to usersend email to j9d9reply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
賣醜也~~~~這個正好我要的

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
Jacky007





發文: 1
積分: 0
於 2005-01-14 15:55 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
非常感谢!

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
zzpaul





發文: 1
積分: 0
於 2005-01-19 17:46 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝~

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
ttoybhw





發文: 2
積分: 0
於 2005-01-22 11:12 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝分享 ^^

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
willy6730





發文: 10
積分: 0
於 2005-01-31 12:15 user profilesend a private message to usersend email to willy6730reply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝error21h無私的分享
馬上去下載!!!
如有問題再向您請教!!!
麻煩您指導一下,感激不盡。


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
Madagascar





發文: 122
積分: 2
於 2005-01-31 14:15 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝您造福大家...太感激了...(泣)

reply to postreply to post
已完成:SCJP 1.4、SCWCD 1.3
今年目標:SCWCD 1.4、SCBCD 1.3
加油!!!
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
edwardhw





發文: 1
積分: 0
於 2005-03-01 09:52 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
非常感謝您的慷慨分享^^

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
ming500





發文: 22
積分: 0
於 2005-03-13 11:39 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
帮主,很精辟啊,谢谢

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
ahkalex





發文: 3
積分: 0
於 2005-03-15 10:25 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
整理的很棒~好專業喔!!! 感恩囉...

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
golde





發文: 7
積分: 0
於 2005-03-25 11:21 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
專業級的筆記....
對於初學者的我受用無窮
感謝前輩..提攜後輩


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
huiwen





發文: 2
積分: 0
於 2005-04-15 09:36 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
謝謝你的分享丫!!! ^^ 感恩咧..

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
mouson





發文: 12
積分: 0
於 2005-05-02 11:52 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
謝謝你的分享
這個真的很讚耶
感謝您熱情的整理與分享


reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
mantat





發文: 1
積分: 0
於 2005-05-10 14:43 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝~Wink

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
hzdzu





發文: 1
積分: 0
於 2005-05-13 00:40 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
大哥,缘分哪!

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
JuiChin





發文: 44
積分: 0
於 2005-06-01 17:36 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感謝的五體投地,跪地拜恩。........^.^

reply to postreply to post
中大獎!哇哈哈哈!先回家睡覺看看能不能夢到。
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
claman





發文: 3
積分: 0
於 2005-06-08 16:10 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
thanks for your notebook

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
058005





發文: 4
積分: 0
於 2005-06-16 16:33 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
很不错哟

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
WayneChang





發文: 6
積分: 0
於 2005-07-08 14:34 user profilesend a private message to usersend email to WayneChangreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
受益良多..感謝分享

reply to postreply to post
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
hoden_w





發文: 6
積分: 0
於 2005-07-19 10:19 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
感谢楼主!!
正急用呢!!
收下了!!!


reply to postreply to post
nEIL
go to first page go to previous page  1   2   3   4  go to next page go to last page
» JWorld@TW »  JDBC/SQL討論區 » Oracle

reply to topicthreaded modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8