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





发布时间: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        ......【阅读全文】

阅读(19697) | 评论(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 ......【阅读全文】

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

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


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

jametong2014-06-27 16:58


回复  |  举报

登录 注册