--创建表
CREATE GLOBAL TEMPORARY TABLE TEST(RoadGuid varchar2(50 byte), RebuildDate DATE)
--插入表
INSERT INTO test (RoadGuid, RebuildDate)
SELECT RoadGuid, RebuildDate
FROM civicism.tbcityration
--查询表
SELECT RoadGuid, RebuildDate FROM TEST
--删除表
DROP TABLE TEST CASCADE CONSTRAINTS
以上语句单独执行都可以通过,希望能够将所有一次性执行,该怎么做。
望高手指教,急!
CREATE GLOBAL TEMPORARY TABLE TEST(RoadGuid varchar2(50 byte), RebuildDate DATE)
--插入表
INSERT INTO test (RoadGuid, RebuildDate)
SELECT RoadGuid, RebuildDate
FROM civicism.tbcityration
--查询表
SELECT RoadGuid, RebuildDate FROM TEST
--删除表
DROP TABLE TEST CASCADE CONSTRAINTS
以上语句单独执行都可以通过,希望能够将所有一次性执行,该怎么做。
望高手指教,急!
小弟刚接触Oracle,不懂啊 谢了
--创建表
CREATE GLOBAL TEMPORARY TABLE TEST(RoadGuid varchar2(50 byte), RebuildDate DATE,IntLogout number(10),RoadInfoID varchar2(50 byte),FenceInfoID varchar2(50 byte))
--插入表
INSERT INTO test (RoadGuid, RebuildDate,RoadInfoID,FenceInfoID, IntLogout)
SELECT RoadGuid, RebuildDate,RoadInfoID,FenceInfoID, IntLogout
FROM civicism.tbcityration
UNION
SELECT RoadGuid, RebuildDate,RoadInfoID,FenceInfoID, IntLogout
FROM civicism.tbcityrationhistory
--查询表
SELECT civicism.tbCityRoadInfo.RoadName, civicism.tbCityFenceInfo.FenceLength,
civicism.tbCityFenceInfo.FenceType, civicism.tbCityFenceInfo.FenceMaterial,
civicism.tbCityRoadInfo.RoadConserveUnit
FROM TEST INNER JOIN
civicism.tbCityRoadInfo ON TEST.RoadInfoID = civicism.tbCityRoadInfo.RowGuid INNER JOIN
civicism.tbCityFenceInfo ON TEST.FenceInfoID = civicism.tbCityFenceInfo.RowGuid
WHERE TEST.RebuildDate IN
(
SELECT MAX(RebuildDate) FROM TEST
WHERE to_char(RebuildDate,'yyyy')<=to_char(sysdate,'yyyy') AND TEST.IntLogout='0' GROUP BY RoadGuid
)
--删除表
DROP TABLE TEST CASCADE CONSTRAINTS
每个语句都单独可以执行,请哪位高手帮我写成一个能一次性直接运行的代码块,谢谢!!
begin
...
end;
在begin 和end之间加入你的代码,注意每条语句后面要有一个分号
静态的SQL一般有SELECT, INSERT, UPDATE, DELETE这四条语句。
动态的SQL语句可以在运行时建立和运行SQL语句。这种SQL语句必须是在运行时才能确定。