jametong的ITPUB博客

暂无签名

  • 博客访问: 93050
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02
ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(47)

文章存档

2005年(47)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

发布时间:2005-04-27 08:39:12

Nag -- Thanks for the question regarding "sql to get data from flat file-- this is mind blowing", version 8.1.7originally submitted on 12-Oct-2001 19:26 Eastern US time, last updated 26-Apr-2005 20:08You Asked "In 9i, with the addition of external tables ( the ability to query a FLAT FILE with SQL) -- SQLLDR might be "moot". Using the external table and the insert /*+ append */ I can basically do a direct path load from file to database without running a command......【阅读全文】

阅读(7656) | 评论(0) | 转发(0)

发布时间:2005-04-27 00:58:48

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:25685777038588in general your query won't get the "next n rows".Why would you not just:select /*+ FIRST_ROWS */ * from ( select /*+ FIRST_ROWS */ a.*, rownum rnum from (select /*+ FIRST_ROWS */ * from t where .... order by ... ) a where rownum <= :MAX_ROW ) where rnum >= :MIN_ROW;done. that is how I write all pagination queries.(you do know that A||B has serious programming issues -- A=1, B=11......【阅读全文】

阅读(29928) | 评论(0) | 转发(0)

发布时间:2005-04-26 07:41:32

The purpose of this document is to provide an easy to use, step by step guide to resolving ORA-04031 errors. Contents: 1. Instance parameters related with the Shared Pool2. Diagnosing ORA-04031 errors3. Resolving error ORA-04031    * Known Oracle BUGs    * ORA-4031 when compiling Java code    * Small shared pool size          o Library Cache Hit Ratio        ......【阅读全文】

阅读(19508) | 评论(0) | 转发(0)

发布时间:2005-04-26 05:29:59

How to get the the date of first day of the week for a given week #? For example, the beginning day for week# 34 in 2003 is AUG-18-2003, how do I find the beginning date for the same week # 34 in 2002? 'iw' can't be used in the to_date function.Thanks! Followup: well, we can use the fact that at least from 1800 to 2199, jan 4th is in the first week... this:ops$tkyte@ORA920> select * 2 from ( 3 select dt1, to_char( dt1, 'yyyy' ), 4 to_char( dt4, 'iw' ), 5 ......【阅读全文】

阅读(2162) | 评论(0) | 转发(0)

发布时间:2005-04-25 11:39:00

如果是真的,那就太恐怖了<<特级警告>>不要和陌生人喝酒(为了人身安全一定要看!!!!!!!!!!!!!)广州大学庆祝期中考结束是个传统。这个男生去参加上星期六晚上的庆祝。他觉得很快乐,喝了很多酒,而且有些女孩对他有兴趣,于是邀请他参加另一个庆祝会。他很快的就答应了,并且自己一个与女孩们坐出租车(有车哦)同去。庆祝会是在另一楼公寓。他们继续地喝酒,并吃了一些不知名的药。等他再醒来,发现他全身赤裸地在浴缸中,而且浴缸里满满的都是冰。药效仍然没对完全退去,不过他看了看四周,发现只有他一个人。他看了自己......【阅读全文】

阅读(2156) | 评论(0) | 转发(0)
给主人留下些什么吧!~~

jametong2014-06-27 16:58

http://lvyou.elong.com/laogt2/tour/a2r0cnvf.html
http://lvyou.elong.com/laogt2/tour/a2rfco0f.html
http://lvyou.elong.com/laogt2/tour/a2r7co1c.html
http://lvyou.elong.com/laogt2/tour/a2r0co27.html

回复  |  举报
留言热议
请登录后留言。

登录 注册