SQL Oracle for rolling the period return
Hi ,  i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query .  return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]

Answer Question   |  May 16, 2011  5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database

Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

Answer Question   |  September 24, 2010  1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select

Oracle SQL-Pagination Help
Hi, The below inner SELECT returns huge amount of rows (1000000+) and the outer SELECTs(alpha BETWEEN #startRec# AND #endRec#) is used for PAGINATION to display data with 25 in each page. Issue is:-This PAGINATION done below is very slow and slows the entire display of data.So could all please help me on doing this below [...]

Answer Question   |  January 2, 2010  4:24 PM
Oracle SQL, Oracle SQL Pagination, Pagination, SELECT statement