Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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.
Connect with top rated Experts
19 Experts available now in Live!