We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
create or replace procedure test() --create a temp table to hold my final results create global temporary table final_results( id varchar2(8), id_num number, comment varchar2(100), comment2 varchar2 (10), total_num number); -- insert some stuff into the final results insert into final_results(id,id_num,comment,comment2) with Letter as ( blah.blah blah..), ... I do a bunch of stuff inbetween and it works fine ... then end my with with a select select id,id_num,comment,comment2 from all; --declare a variable to store a value DECLARE a NUMBER; BEGIN SELECT count(employee_id) INTO a FROM employee; update final_results set total_num = a; END; -- get my results from the final_results table select * from final_results -- drop my temp table drop table final_resul;ts;
Join the community of 500,000 technology professionals and ask your questions.