I used Oracle for the first time in my life today - thanks to help from David Haines - it was not nearly as scary as I had imagined. David told me about henplus - which is the "vi" of database debugging tools - fits my style perfectly.
He walked me through my properties and getting connected to the database. Once connected - it felt a lot like any other database. Hey - put semicolons at the end.
The MailArchive paging code came together in three compiles. Here are some cool queries.
select * from ( select a.*, rownum rnum from ( select XML from MAILARCHIVE_MESSAGE where (CHANNEL_ID = ? ) order by MESSAGE_DATE desc ) a where rownum <= 20 ) where rnum >= 11
Note that the rows start from 1 - unlike the LIMIT in HSQL or MySql - where the rows start from zero. But all in all pretty straightforward.
Posted by csev at February 11, 2008 08:36 PM