home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,488 of 2,288   
   Paulos to All   
   If exists in PL/sql   
   09 Jun 04 19:34:33   
   
   From: paulos-spamfree@skynet.be   
      
   Hi Guys   
      
   I am a bit of a nocice at some aspects of PL/SQL and I have to write some   
   code in a function that checks if a row in a given table exists...something   
   on the lines of :   
      
   IF( exists(select 'x' from table) then   
       do stuff   
   else   
       do other stuff   
      
   end if;   
      
   Is there a quick and efficient way of doing this?   
      
   Thnx   
      
   Paulos   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca