One thought on “POW Answer – Fill In The Blanks In SQL”

  1. select x.newid from
    (select level newid from dual
    connect by level <
    (select max(oldid) from sparse_table)
    ) x
    left join sparse_tablec on c.oldid= x.newid
    where c.oldid is null

    — using Oracle 10

Leave a Reply

Your email address will not be published. Required fields are marked *


8 − = six

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="">