Extensions Version 0.8.4
- Added support for named JDBC parameters
SELECT * FROM mytable WHERE b = :param- Added support for pivot expressions
- Added support for boolean functions in where statements
select * from my_table where bool_func(col)- Added support for Oracles old join syntax for more compare operations
select * from taba, tabb where taba.a<tabb.a(+)- Added support for foreign keys in create table statements
create table testTable1 (a varchar(10), b varchar(20), foreign key a references testTable2(a))
create table testTable1 (a varchar(10), b varchar(20), constraint fkIdx foreign key a references testTable2(a))- Added support for simple intervals
select 5 - INTERVAL '45 MINUTE' from mytable- Added support for multi values IN expression
select * from mytable where (a,b,c) in (select a,b,c from mytable2)