Link to home
Start Free TrialLog in
Avatar of gritscbs
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;
ASKER CERTIFIED SOLUTION
Avatar of gnovakhs2n
gnovakhs2n
Flag of Austria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial