Update p_new as n inner join p_old as o on n.pro_id=o.pro_id set n.pro_feature=case when o.pro_feature='1' then 'Y' when o.pro_feature='0' then 'N' end;
oracle error='missing set keyword';
No Comments Posted for this Article.
1. What are database authorizations? For security reasons, it does not make sense to grant database users access to all database resources, or to permit all actions. Therefore, it is usually cause...