apache / apache/shardingsphere

Some Oracle SQL statements are not supported and require enhancing the parsing module.

Open
#28,387 3 comments 0 reactions 1 assignee Claimed by @zihaoAK47 View on GitHub
db: Oracle in: SQL parse
Dominant language
Java
Stars
20.8k
Forks
6.9k
Avg merge
11h 35m
Merged PRs (30d)
326

Description

- [ ] create sequence LAB_SAMPLES_SEQ
- [ ] insert into moons values ('','',)
- [ ] create or replace view named_moons as select p.name planet, p.class, m.name moon, m.radius from planets p, moons m where p.name = m.planet_name(+) and m.name(+) not like 'S/%'
- [ ] create or replace function LAST_CLOSE(p_close_date date) return number is begin return case to_char(p_close_date,'DY') when 'SUN' then 2 when 'MON' then 3 else 1 end
- [ ] select owner, approx_count(*) , approx_rank(partition by owner order by approx_count(*) desc) from t group by owner having approx_rank(partition by owner order by approx_count(*) desc) <= 1 order by 1

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.