defaria.com/blogs/Status/archives/000632.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml" />
  11
  12    <title>Status for Andrew DeFaria: Oracle limit clause</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/000631.html" title="Deleting Site Domains" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000633.html" title="Turning on HTML for Exchange/IMAP" />
  17
  18    <!--
  19 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  20          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  21          xmlns:dc="http://purl.org/dc/elements/1.1/">
  22 <rdf:Description
  23     rdf:about="http://defaria.com/blogs/Status/archives/000632.html"
  24     trackback:ping="http://defaria.com/mt/mt-tb.cgi/21"
  25     dc:title="Oracle limit clause"
  26     dc:identifier="http://defaria.com/blogs/Status/archives/000632.html"
  27     dc:subject="GPDB"
  28     dc:description=" Modify site almost functionally complete Looking into how to do what MySQL does with it&apos;s limit clause in Oracle..."
  29     dc:creator=""
  30     dc:date="2007-04-18T19:04:09-06:00" />
  31 </rdf:RDF>
  32 -->
  33
  34
  35
  36
  37    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  38 </head>
  39 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  40    <div id="container">
  41       <div id="container-inner" class="pkg">
  42
  43          <div id="banner">
  44             <div id="banner-inner" class="pkg">
  45                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  46                <h2 id="banner-description">Searchable status reports and work log</h2>
  47             </div>
  48          </div>
  49
  50          <div id="pagebody">
  51             <div id="pagebody-inner" class="pkg">
  52                <div id="alpha">
  53                   <div id="alpha-inner" class="pkg">
  54
  55                      <p class="content-nav">
  56                         <a href="http://defaria.com/blogs/Status/archives/000631.html">&laquo; Deleting Site Domains</a> |
  57                         <a href="http://defaria.com/blogs/Status/">Main</a>
  58                         | <a href="http://defaria.com/blogs/Status/archives/000633.html">Turning on HTML for Exchange/IMAP &raquo;</a>
  59                      </p>
  60
  61                      <a id="a000632"></a>
  62                      <div class="entry" id="entry-632">
  63                         <h3 class="entry-header">Oracle limit clause</h3>
  64                         <div class="entry-content">
  65                            <div class="entry-body">
  66                               <ul>
  67   <li>Modify site almost functionally complete</li>
  68
  69   <li>Looking into how to do what MySQL does with it's limit clause in Oracle</li>
  70 </ul>
  71                            </div>
  72                            <div id="more" class="entry-more">
  73                               <h2>Oracle limit clause</h2>
  74
  75 <p>Found this ugly workaround for MySQL's limit clause:</p>
  76
  77 <div class=code><pre>
  78 select * from (
  79   select rownum as limit, t.* from (
  80     select * from &lt;table&gt; where &lt;condition&gt;
  81   )
  82 t) where limit between &lt;lower limit&gt; and &lt;upper limit&gt;
  83 </pre></div>
  84
  85 <p>Hey it works....</p>
  86                            </div>
  87                         </div>
  88                         <p class="entry-footer">
  89                            <span class="post-footers">Posted by  on April 18, 2007  7:04 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000632.html">Permalink</a>
  90                         </p>
  91                      </div>
  92
  93
  94                      <div class="trackbacks">
  95                         <h3 id="trackback" class="trackbacks-header">TrackBack</h3>
  96                         <div id="trackbacks-info">
  97                            <p>TrackBack URL for this entry:<br />http://defaria.com/mt/mt-tb.cgi/21</p>
  98                         </div>
  99                         <div class="trackbacks-content">
 100
 101                         </div>
 102                      </div>
 103
 104
 105
 106                   </div>
 107                </div>
 108             </div>
 109          </div>
 110       </div>
 111    </div>
 112 </body>
 113 </html>