My main Editor is EmEditor.
Many Editor supports IntelliSense each extention (Ex SQL,cpp,cs,vb,bat,js ...)
And I am using below IntelliSense of SQL Statements.
My question is what is your IntelliSense of SQL Statements.
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 '
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 WorkView as (select
'YYYY/MM/DD HH24:MI:SS'