Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    14

    Unanswered: Executing Multiple Statements

    Is it possible to execute the following all inone PL/SQL Anonymous Procedure:

    begin

    update SYS.XX_MTL_SYS_ITEMS_INTERFACE
    set Start_Date_Active = NULL
    where Length(Trim(Start_Date_Active)) Is Null

    update SYS.XX_MTL_SYS_ITEMS_INTERFACE
    set End_Date_Active = NULL
    where Length(Trim(ENd_Date_Active)) Is Null

    insert into SYS.MTL_SYSTEM_ITEMS_INTERFACE
    select * from SYS.XX_MTL_SYS_ITEMS_INTERFACE

    end;

    Or do I have to put somethng in between the update statements.

    Thanks for your help
    Mark

  2. #2
    Join Date
    Oct 2003
    Location
    Montreal
    Posts
    10
    Simply add a semi-column after each update statement

  3. #3
    Join Date
    Oct 2003
    Posts
    14
    Thanks very much for your help. Appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •