DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: pl/sql conditions

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    pl/sql conditions

    Hi Friends,

    I'm still learming pl/sql
    I have a code like this

    begin
    select * from emp where ename like 'DAVE%';
    if (data_found)
    then
    update count_tab set hits=hits+1;
    end if;
    exception
    when no_data_found
    then
    update count_tab set no_hits=no_hits+1;
    end;


    I don't know what "word" to substitute the condition "(data_found)"
    that is the opposite of "NO_DATA_FOUND" condition/exception.
    Is there a condition "DATA_FOUND"?


    Thanks a lot....

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Its called sql%found

    read about implicit cursors in pl/sql manuals

    regards
    Hrishy

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    thats it ...thanks hun
    Why is that i havent read any of the pl/sql demo example using
    this sql%found thing, u know i only learn programming by those examples

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by kris123
    thats it ...thanks hun
    Wow Hrishy I didn't know you two were dating
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi OracleDoc

    I dont mind datimg until such time Kris123 is someone like kristina :-) a gurl

    regards
    Hrishy

Posting Permissions

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


Click Here to Expand Forum to Full Width