apache / apache/shardingsphere
Some Oracle SQL statements are not supported and require enhancing the parsing module.
- 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
Assessment
This issue has not been assessed yet.