It has error in both places (1) before BEGIN and (2) after BEGIN. What is the correct syntax? Can I select * from CityTemp? Thanks.
PROCEDURE TempTable AS
create global TEMPORARY table CityTemp
(
city varchar2(20),
state varchar2(2),
county varchar(20)
);
BEGIN
insert into CityTemp
select * from citystate;
select * from CityTemp;
END;