1
  • 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...

    Piyushr15 pointsBadges:
  • 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.

    jakusza30 pointsBadges:
  • 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...

    Rohit331225 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following