gritscbs
asked on
if (select...) = x then create table command doesn't work Oracle 10g - please assist
I am trying to create a new table when the status in another table = Yes and need help making this work. Your assistance is appreciated.
(if select status from desaim_status where project_file_id = 2993;) = 'Yes';) then
create table desaim2993 as select * from inven_items_tracking where project_file_id = 2993;
(if select status from desaim_status where project_file_id = 2993;) = 'Yes';) then
create table desaim2993 as select * from inven_items_tracking where project_file_id = 2993;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.