INSERT INTO

From: colmkav <colmjkav_at_yahoo.co.uk>
Date: Thu, 07 Jun 2007 05:36:59 -0700
Message-ID: <1181219819.295979.325870@h2g2000hsg.googlegroups.com>

Anyone know why this code gets an error "ORA-00911: invalid character"?

    INSERT INTO ta_tmp(description)

      SELECT DISTINCT description
      FROM t_exposuretype
      WHERE description not in (select description from

ta_exposuretype);

The Select part works fine. Received on Thu Jun 07 2007 - 07:36:59 CDT