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

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

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





發文: 6
積分: 0
於 2005-08-15 10:23 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

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





發文: 1
積分: 0
於 2005-08-17 21:50 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....T_T

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





發文: 18
積分: 0
於 2005-09-02 10:08 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]
superjavaworld





發文: 2
積分: 0
於 2005-09-09 13: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
thanks

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





發文: 9
積分: 0
於 2005-09-20 10:50 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.....Big Smile


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





發文: 1
積分: 0
於 2005-10-05 17:44 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
我灌的是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其它型式??

你可以用 to_date(20040101,'yyyymmdd')
如果要時分秒,則用 to_date(20040101235959,'yyyymmddhh24miss')


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





發文: 1
積分: 0
於 2005-10-05 22:49 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

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





發文: 3
積分: 0
於 2005-10-10 03:41 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]
hulihunter





發文: 2
積分: 0
於 2005-11-10 14:48 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]
yenf





發文: 8
積分: 0
於 2005-11-18 21:29 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
感謝您,正好為sql所苦,謝謝分享

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

~Nintendo64~



發文: 686
積分: 3
於 2005-11-22 10:14 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的斷行真機車Disapproved


reply to postreply to post

Focus TDCi Powershift,純正德國血統
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
sming





發文: 4
積分: 0
於 2005-11-22 17:00 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]
chrase1





發文: 10
積分: 0
於 2005-12-18 11:39 user profilesend a private message to usersend email to chrase1reply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
謝謝前輩的分享,浪後輩人吃到前輩的果實...............................thx thx thx......

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





發文: 4
積分: 0
於 2005-12-30 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
...讚...讚...讚...

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





發文: 1
積分: 0
於 2006-05-18 20: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
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
xyq575





發文: 28
積分: 0
於 2006-05-23 13:41 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]
hugohugo64





發文: 120
積分: 0
於 2006-05-24 09:36 user profilesend a private message to usersend email to hugohugo64reply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
thank you!

reply to postreply to post
~永無止境!~
作者 Re:[分享] 我的 Oracle9i: SQL 筆記 [Re:error21h]
lion_k_ring





發文: 2
積分: 0
於 2006-05-29 03: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
謝謝 error21h大 無私的分享 弟剛好這陣子在學 Oracle 不過 弟 看不懂 大大 你的筆記 囧

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





發文: 35
積分: 0
於 2006-06-01 15:08 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]
chain710915





發文: 71
積分: 0
於 2006-06-02 10:42 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
簡短有力的筆記,很用心,感謝您無私的分享,Big Smile

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





發文: 1
積分: 0
於 2006-06-02 14: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
嘻~~真好用也很詳細~~
謝謝啦~~Wink


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





發文: 1
積分: 0
於 2006-06-07 16:32 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]
blliy118





發文: 8
積分: 0
於 2006-06-07 23:50 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]
uaejefa





發文: 1
積分: 0
於 2006-07-04 10: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
感謝大大分享~~~

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





發文: 2
積分: 0
於 2006-08-04 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
谢谢您的分享!

reply to postreply to post
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