One Reply to “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 *