No, I'm afraid not. What's your final output? If its a report, you may want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this requirement.
On Sat, Jan 11, 2014 at 8:49 AM, Cecil Westerhof <[email protected]>wrote: > 2014/1/11 Atul Chowdhury <[email protected]> > >> You're probably after something like the BREAK directive found in >> SQL*Plus. >> >> See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm >> >> SQL> BREAK ON DEPTNO >> SQL> SELECT DEPTNO, ENAME, SAL >> 2 FROM EMP >> 3 WHERE SAL < 2500 >> 4 ORDER BY DEPTNO; >> SQL*Plus displays the following output: >> DEPTNO ENAME SAL >> ---------- ----------- --------- >> 10 CLARK 2450 >> MILLER 1300 >> 20 SMITH 800 >> ADAMS 1100 >> 30 ALLEN 1600 >> JAMES 950 >> TURNER 1500 >> WARD 1250 >> MARTIN 1250 >> > > Yes, that is exactly what I want. This is not possible in H2? > > -- > Cecil Westerhof > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
