■元あるテーブルからテンポラリテーブルを簡単に作成する
create table renepat_web.rp_search_index_005 as
select a.hatsumei_no, a.kuni_eda, a.touroku_no from renepat_web.rp_shutsugan a
where a.touroku_no is not null

■差集合
(SELECT * FROM RP_MENU_MST@MATSU
MINUS
SELECT * FROM RP_MENU_MST)
UNION ALL
(SELECT * FROM RP_MENU_MST
MINUS
SELECT * FROM RP_MENU_MST@MATSU);

■抜け番検索
SELECT
MIN(NO + 1)
FROM
RP_GYOMU_KUBUN G1
WHERE
NOT EXISTS (
SELECT
*
FROM
RP_GYOMU_KUBUN G2
WHERE
G2.NO= G1.NO+ 1;