... darkrealms ...

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 726 of 2,288

Frank to Christine

Re: how to use select clause in assignme

28 Nov 03 09:08:41

   From: fbortel@nescape.net   
      
   Christine wrote:   
   > like this,   
   >   
   > EXECUTE IMMEDIATE 'select empno from part where partid = '||part_id into   
   myid;   
      
   Use BIND variables:   
   EXECUTE IMMEDIATE 'select empno from part where partid = :a'   
   using part_id   
   into myid;   
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

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