USE 'IN' OR 'ANY' OR 'ALL' OPERATORS On 12/9/08, Vlad <[EMAIL PROTECTED]> wrote: > > I'm trying to update portlet.description with the value of > param_exception.param_char_val where there is a match on portlet code. > > I only want this to occur when > param_exception.param_name='portlet_title' and param_char_val is not > null. > > I'm banging my head against the following - I keep getting a single- > row subquery error. > > Any ideas? > > TIA > > > UPDATE portlet A > SET A.description = ( SELECT B.param_char_val > FROM param_exception B > WHERE A.portlet_code = B.portlet_code > and B.param_name = 'portlet_title' > and B.param_char_val is not null) > WHERE EXISTS ( SELECT B.param_char_val > FROM param_exception B > WHERE A.portlet_code = B.portlet_code > and B.param_name = 'portlet_title' > and B.param_char_val is not null > ) > > >
-- jomesh joseph veliyath --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
