トップページに戻る    前のOracleツールへ

エディタのオートコンプリートに、
よく使うSQL文の一部を設定しておくと、SQL文を作成する時に便利です。


私が使用してるオートコンプリート

add_months(
all_catalog
between ■■■ and ■■■
case when ■■■ then ■■■ else ■■■ end
coalesce(
connect by prior
connect_by_IsLeaf = 1
connect_by_root
count(*) from
create or replace procedure
create table
cursor カーソル is select
DBMS_Output.Put_Line(
delete from
distinct
elsif
end if;
end Loop;
exists(select 1 from
First_Value(■■■) over(partition by ■■■ order by ■■■)
for I in 1..100 Loop
for rec in (select ) Loop
from dual
group by
having
if 条件式 then
ignore nulls
insert into
intersect select
is not null
is null
Keep(Dense_Rank First order by ■■■)
Lag(■■■) over(partition by ■■■ order by ■■■)
Last_day(
Lead(■■■) over(partition by ■■■ order by ■■■)
Lengthb(
Like '
ListAgg(■■■,',') WithIn group(order by ■■■) as ■■■
minus select
model dimension by (■,■) measures(■,■) rules iterate(10) (■,■);
months_between(
not exists(select 1 from
Ntile(■■■) over(partition by ■■■ order by ■■■)
nullif(
order by
over(partition by ■■■ order by ■■■)
partition by
pls_Integer;
Prior
range between Unbounded Preceding and Unbounded Following
replace(
round(
RegExp_Like(対象文字列,マッチパターン)
RegExp_Instr(対象文字列,マッチパターン)
RegExp_Substr(対象文字列,マッチパターン)
RegExp_Replace(対象文字列,マッチパターン,置換文字列)
RowID
RowNum
Rows between Unbounded Preceding and Unbounded Following
Row_Number() over(partition by ■■■ order by ■■■)
set autotrace traceonly explain
start with
sys_connect_by_path(
to_char(
to_date(
to_number(
truncate table
union all select
update ■■■ set
values(
with tmp as(
wmsys.wm_concat(■■■) as ■■■
'YYYY-MM-DD HH24:MI:SS'

EmEditor
EmEditorのオートコンプリートプラグイン(AutoComplement)