PL/SQL (MOSC)

MOSC Banner

Insert Into Table using a cursor in 11g

edited Dec 11, 2012 4:43AM in PL/SQL (MOSC) 6 commentsAnswered ✓
 I'm new to cursors FYI.  All I want to do is truncate a temp table then insert into it. I want to convert this procedure to use a cursor:  I'm not sure if I want a bulk insert or if I need some kind of loop.
PROCEDURE FIX_PUBLISHED ()
AS
BEGIN
   DBMS_UTILITY.EXEC_DDL_STATEMENT ('TRUNCATE TABLE TMP_FIX_PUBLISHED;');

   INSERT INTO TMP_FIX_PUBLISHED
      SELECT DISTINCT CL.LISTED_TN, GAPL.PUBLISHEDNUMBER
        FROM item,
             tbprodni,
             tbnationalsectionxref,
             tbproduct,
             cust_listing cl,
             tbudac,
             CUSTOMERINFO.CMS_GAP_PROGRAM gapp,
             CUSTOMERINFO.CMS_GAP_PROGRAM_ITEM gapi,
             CUSTOMERINFO.CMS_GAP_STATUS_TRACKING gaps,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center