Hi Tom, I’ve been reading through a few posts regarding pagination. I’m using the following query template in my application, to implement a "previous", "next" feature to page through a search resultset: (J2EE front-end calls a stored proc returni…
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 [...]
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 [...]