One of the new mapping operators introduced in 11gR2 is the much talked about (over the years) subquery filter operator. As well as the heterogeneous capabilities added, a number of enhancements to existing operators (such as joiner and lookup operator) and a few new ones were added. The subquery filter supports the SQL grammar for [...]
I am in a java mood today, let’s check how to print hello world with jdbc
import java.sql.*;
public class HelloWorld {
public static void main(String[] args) throws SQLException {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
ResultSet res = DriverManager.
getConnection("jdbc:oracle:thin:@srv1:1521:DB01", "scott", "tiger").
prepareCall("select 'Hello World' txt from dual").
executeQuery();
res.next();
System.out.println(res.getString("TXT"));
}
}
let’s compile
javac -classpath $ORACLE_HOME/jdbc/lib/classes12.jar HelloWorld.java
and run
$ java -classpath $ORACLE_HOME/jdbc/lib/classes12.jar:. HelloWorld
Hello World
that’s all folks!
Link to the original site
This is asked over and over in the forums, but why not proposing an 11g solution here
create table t(description varchar2(12) primary key,
numbers varchar2(4000));
insert into t(description, numbers) values ('PRIME','2,3,5,7');
insert into t(description, numbers) values ('ODD','1,3,5,7,9');
commit;
DESCRIPTION
NUMBERS
PRIME
2,3,5,7
ODD
1,3,5,7,9
Now I want to unpivot numbers in rows
select description,(column_value).getnumberval()
from t,xmltable(numbers)
DESCRIPTION
(COLUMN_VALUE).GETNUMBERVAL()
PRIME
2
PRIME
3
PRIME
5
PRIME
7
ODD
1
ODD
3
ODD
5
ODD
7
ODD
9
It is that simple
Works also with strings :
select (column_value).getstringval()
from xmltable('"a","b","c"');
(COLUMN_VALUE).GETSTRINGVAL()
a
b
c
Link [...]