Oracle pagination query example

-
    select
        * 
    from
        ( select
            row_.*,
            rownum rownum_ 
        from
            ( 
YOUR SELECT STATEMENT WITH WHERE,GROUP,ORDER,AGGREGATES,ETC

  ) row_ ) 
        where
            rownum_ <= ? 
            and rownum_ > ?

Comments

Post a Comment

Popular posts from this blog

SSL certification of you web site

-
This will create a certification file and send to free certification authority " https://certbot.eff.org " sponsored by linux foundation. Following are for apache deployment on Ubuntu compatible. For other configurations visit https://certbot.eff.org sudo apt-get install python-letsencrypt-apache sudo letsencrypt --apache
Read more

Running Local LLMs for Cursor IDE: A Quick Guide to Ollama Integration

-
Image
Running Large Language Models (LLMs) locally are becoming increasingly accessible, and integrating them directly into your IDE workflow can dramatically boost productivity if you got some good hardware already. This guide demonstrates how to run LLMs locally using Ollama and connect with Cursor IDE. 1. Setting Up Ollama Ollama local LLM deployment. Install Ollama: Follow the installation instructions for your operating system: https://ollama.com/docs/install   set these envs: export OLLAMA_ORIGINS=*             export OLLAMA_HOST=0.0.0.0:11434   Start the Model: Run ollama serve & to launch the LLM server in the background.  run ollama and pull models: ollama serve & ollama pull llama3.1:8b   Pull a Model: Let's start with llama3.1:8b . Run ollama pull llama3.1:8b . This downloads the model – you can explore other models on the Ollama website ( https://ollama.com/library ). You'll see a list of available mod...
Read more

Installing MPICH2 on Ubuntu

-
Image
Installing MPICH2 parallel computing from package manager or Ubuntu software center, will need lot configurations of available real processors in the system environment. There for using MPICH2 from available .tar or .gz package is easier. To download MPICH2 package goto here: http://www.mcs.anl.gov/research/projects/mpich2/downloads/index.php?s=downloads or use here Direct link for mpich2-1.3a2.tar.gz change user to root or user super user privilege on every command sudo -i cd to the package location : #cd /location Then uncompress the package #tar xzvf filename.tar.gz go to the 'package root' : #cd filename then configure environment #./configure compile the package # make install the compiled package #make install Another small thing to do to start the mpich2 daemon: insert the following 3 lines to the /usr/local/bin/mpdlib.py as root import warnings warnings.filterwarnings('ignore', '.*the md5 module is deprecated.*', Depr...
Read more