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
)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
