Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Location
    Canada
    Posts
    1

    Unanswered: IF NOT EXISTS in Oracle?

    is oracle capable of doing this?

    IF NOT EXISTS( SELECT item_id from PROJECT_WMS_TEMP where item_id = ITEM_ID) THEN
    BUILD_PROJECT_WMS_TEMP;
    End If;
    Thanks
    Christian

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    you can use PL/SQL Funktion in a SQL statement

    something like ...

    BEGIN
    SELECT ...
    EXCEPTION
    WHEN NO_DATA_FOUND THEN
    call proc;
    END;

    Hope this help ?

    Greetings
    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

    *** did you ever use Oracle, MySQL, Interbase and Birdstep with one tool ? No ? Try AlligatorSQL ... ***

Posting Permissions

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