Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Let us share IntelliSense of SQL Statements

Aketi JyuuzouMay 31 2011 — edited Jun 1 2011
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'

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 29 2011
Added on May 31 2011
5 comments
524 views