Where :
FIRST_ROWS(N) tells the optimizer, "Hey, I'm interested in getting the first rows, and I'll get N of them as fast as possible.":MAX_ROW_TO_FETCH is set to the last row of the result set to fetch—if you wanted rows 50 to 60 of the result set, you would set this to 60.:MIN_ROW_TO_FETCH is set to the first row of the result set to fetch, so to get rows 50 to 60, you would set this to 50.Source https://blogs.oracle.com/oraclemagazine/on-rownum-and-limiting-results
| #!/usr/bin/env python | |
| # | |
| # s.py - a simple port forwarder using asyncore | |
| # | |
| # by Yusuke Shinyama, *public domain* | |
| # http://www.unixuser.org/~euske/python/s.py | |
| # | |
| import sys, socket, asyncore |
| brew cask install docker |
| #!/usr/bin/env bash | |
| REQS_MD5=$(md5 -q requirements.txt $(cat requirements.txt | grep "^-r " | cut -d " " -f 2)) | |
| if [ ! -f .direnv/reqs_md5 ] || [ "$(cat .direnv/reqs_md5)" != "${REQS_MD5}" ]; then | |
| echo "Installing python requirements" | |
| pip3 install -r requirements.txt | |
| mkdir -p .direnv | |
| echo ${REQS_MD5} > .direnv/reqs_md5 | |
| else | |
| echo "Python requirements up to date" | |
| fi |
| WORDFILE="/usr/share/dict/words" | |
| NUMWORDS=1 | |
| #Number of lines in $WORDFILE | |
| tL=`awk 'NF!=0 {++c} END {print c}' $WORDFILE` | |
| while : | |
| do | |
| rnum=$((RANDOM%$tL+1)) | |
| sed -n "$rnum p" $WORDFILE |
| # | |
| # Author: Brian Beffa <brbsix@gmail.com> | |
| # Original source: https://brbsix.github.io/2015/11/29/accessing-tab-completion-programmatically-in-bash/ | |
| # License: LGPLv3 (http://www.gnu.org/licenses/lgpl-3.0.txt) | |
| # | |
| get_completions(){ | |
| local completion COMP_CWORD COMP_LINE COMP_POINT COMP_WORDS COMPREPLY=() | |
| # load bash-completion if necessary |
| #!/bin/sh | |
| DOMAIN=${1:-localhost} | |
| openssl genrsa -out $DOMAIN.key 2048 | |
| openssl req -new -x509 -key $DOMAIN.key -out $DOMAIN.cert -days 3650 -subj /CN=$DOMAIN |
| # Extremely basic development setup to serve the current directory at http://localhost:9001 | |
| # Start nginx in this directory with `nginx -p . -c $PWD/nginx.conf` | |
| # Stop nginx with `nginx -p . -s stop` | |
| events {} | |
| daemon off; | |
| http { | |
| # Serve files with correct mimetypes on OSX | |
| # location may have to be adjusted depending on your OS and nginx install |
| cat image.jpg | base64 | vault write /secret/image.jpg value=- | |
| vault read -format=raw -field=value /secret/image.jpg | base64 --decode > image.out.jpg |
| layout python | |
| PATH_add bin | |
| ENVCHAIN_NS=qs-ovh-cloud | |
| if [ -z "$OS_PASSWORD" ]; then | |
| if type envchain > /dev/null; then | |
| echo "Loading OS_PASSWORD env var from keychain" | |
| direnv_load envchain $ENVCHAIN_NS direnv dump | |
| else | |
| echo |