Oracle select multi rows random

 

select B.*, to_char(B.Rand, '0XXXXX') Str from

(

 select A.*, trunc(DBMS_RANDOM.value(A.L, A.H)) Rand from

 (

   select level no,

      200000+level*100000 L,

      200000+level*100000+50000 H

   from dual connect by level <= 100

 ) A

) B

;

NO     L        H       RAND STR

---------- ---------- ---------- ---------- -------

1     300000   350000     317314  04D782

2     400000   450000     408319  063AFF

3     500000   550000     538362  0836FA

4     600000   650000     633656  09AB38

5     700000   750000     724852  0B0F74

6     800000   850000     823489  0C90C1

7     900000   950000     948578  0E7962

8    1000000 1050000    1026192  0FA890

9    1100000 1150000    1107769  10E739

10    1200000 1250000    1221980  12A55C

11    1300000 1350000    1338767  146D8F

12    1400000 1450000    1418473  15A4E9

13    1500000 1550000    1522499  173B43

14    1600000 1650000    1646482  191F92

15    1700000 1750000    1746193  1AA511

16    1800000 1850000    1815369  1BB349

17    1900000 1950000    1923534  1D59CE

18    2000000 2050000    2030796  1EFCCC

19    2100000 2150000    2149042  20CAB2

20    2200000 2250000    2202140  219A1C

Tiny Core Linux - sftp

 

/usr/local/etc/ssh/sshd_config

Match User ftp1

        ChrootDirectory /ftp

        X11Forwarding no

        AllowTcpForwarding no

        ForceCommand internal-sftp 

/etc/passwd

ftp1:x:1000:1000:Linux User,,,:/upload:/bin/false

drwxr-xr-x 3 root root 60 Jan 28 11:02 /ftp

drwxrwxr-x 2 root ftp1 60 Jan 28 11:03 /ftp/upload

Windows 10 file explorer border / title bar color

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\DWM]

"Composition"=dword:00000001

"ColorizationColor"=dword:c40078d7

"ColorizationColorBalance"=dword:00000059

"ColorizationAfterglow"=dword:c40078d7

"ColorizationAfterglowBalance"=dword:0000000a

"ColorizationBlurBalance"=dword:00000001

"EnableWindowColorization"=dword:00000001

"ColorizationGlassAttribute"=dword:00000001

"AccentColor"=dword:ffd77800

"ColorPrevalence"=dword:00000001

"EnableAeroPeek"=dword:00000000

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Themes\Personalize]

"ColorPrevalence"=dword:00000000

"EnableTransparency"=dword:00000001

"AppsUseLightTheme"=dword:00000001

"SystemUsesLightTheme"=dword:00000000

[HKEY_CURRENT_USER\Control Panel\Colors]

"ActiveBorder"="180 180 180"

"ActiveTitle"="153 180 209"

"AppWorkspace"="171 171 171"

"Background"="0 0 0"

"ButtonAlternateFace"="0 0 0"

"ButtonDkShadow"="105 105 105"

"ButtonFace"="240 240 240"

"ButtonHilight"="255 255 255"

"ButtonLight"="227 227 227"

"ButtonShadow"="160 160 160"

"ButtonText"="0 0 0"

"GradientActiveTitle"="185 209 234"

"GradientInactiveTitle"="215 228 242"

"GrayText"="109 109 109"

"HilightText"="255 255 255"

"HotTrackingColor"="0 102 204"

"InactiveBorder"="244 247 252"

"InactiveTitle"="191 205 219"

"InactiveTitleText"="0 0 0"

"InfoText"="0 0 0"

"InfoWindow"="255 255 225"

"Menu"="240 240 240"

"MenuBar"="240 240 240"

"MenuText"="0 0 0"

"Scrollbar"="200 200 200"

"TitleText"="0 0 0"

"Window"="255 255 255"

"WindowFrame"="100 100 100"

"WindowText"="0 0 0"

"Hilight"="0 120 215"

"MenuHilight"="0 120 215"

[HKEY_CURRENT_USER\Control Panel\Desktop\Colors]

"ActiveBorder"="212 208 200"

"ActiveTitle"="10 36 106"

"AppWorkSpace"="128 128 128"

"ButtonAlternateFace"="181 181 181"

"ButtonDkShadow"="64 64 64"

"ButtonFace"="212 208 200"

"ButtonHiLight"="255 255 255"

"ButtonLight"="212 208 200"

"ButtonShadow"="128 128 128"

"ButtonText"="0 0 0"

"GradientActiveTitle"="166 202 240"

"GradientInactiveTitle"="192 192 192"

"GrayText"="128 128 128"

"Hilight"="10 36 106"

"HilightText"="255 255 255"

"HotTrackingColor"="0 0 128"

"InactiveBorder"="212 208 200"

"InactiveTitle"="128 128 128"

"InactiveTitleText"="212 208 200"

"InfoText"="0 0 0"

"InfoWindow"="255 255 255"

"Menu"="212 208 200"

"MenuText"="0 0 0"

"Scrollbar"="212 208 200"

"TitleText"="255 255 255"

"Window"="255 255 255"

"WindowFrame"="0 0 0"

"WindowText"="0 0 0"

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Accent]

"AccentPalette"=hex:a6,d8,ff,00,76,b9,ed,00,42,9c,e3,00,00,78,d7,00,00,5a,9e,\

  00,00,42,75,00,00,26,42,00,f7,63,0c,00

"StartColorMenu"=dword:ff9e5a00

"AccentColorMenu"=dword:ffd77800

Google Chrome security error page

 type "thisisunsafe"

certificate expired/error

HSTS

Windows 7 ad hoc share wifi internet

 

https://www.pcninja.us/turn-your-windows-7-laptop-into-a-wifi-hotspot/

netsh wlan set hostednetwork mode=allow ssid=MyNetworkhere key=Password

netsh wlan start hostednetwork

select the network adapter to share enable "Allow other network users to connect…"

netsh wlan stop hostednetwork

Raspberry Pi

Download image

https://www.raspberrypi.org/downloads/

unzip xxx.zip

dd if=xxx.img of=/dev/sdx bs=100M

-- or --

unzip -p xxx.zip  | sudo dd of=/dev/sdx bs=100M

* first time boot will resize root partition

  cmdline.txt:

   init=/usr/lib/raspi-config/init_resize.sh   

config:

raspi-config

/boot/config.txt

https://www.raspberrypi.org/documentation/configuration/config-txt/boot.md

# GPU Memory
gpu_mem=512

# 

disable_overscan=1

# Disable rainbow image at boot

disable_splash=1

/boot/cmdline.txt

https://www.raspberrypi.org/documentation/configuration/cmdline-txt.md

# Disable boot logo (top left)

logo.nologo

# change boot message to tty3 (no boot message)

console=tty3

Boot splash:

/usr/share/plymouth/themes/pix/splash.png

default user/password: pi/raspberry

No Mouse Pointer / no screensaver:

/etc/lightdm/lightdm.conf

[SeatDefaults]

xserver-command=X -s 0 -dpms -nocursor

change background:

DISPLAY=:0.0 pcmanfm --set-wallpaper xxx.jpg

Error: desktop manager is not active

run from cron:

export DISPLAY=:0.0

export XAUTHORITY=/home/pi/.Xauthority # ???

export XDG_RUNTIME_DIR='/run/user/1000'

pcmanfm --set-wallpaper xxx.jpg

pcmanfm --reconfigure --display=:0.0

change IP:

https://www.raspberrypi.org/documentation/configuration/tcpip/

/etc/dhcpcd.conf

interface eth0

static ip_address=192.168.0.4/24    

static routers=192.168.0.254

static domain_name_servers=192.168.0.254 8.8.8.8

profile ssid_xxx

    ipv4only

    static ip_address=192.168.4.2/24

ssid xxx

   fallback ssid_xxx

ssid yyy

   static ip_address=192.168.4.3/24

Wifi:

/etc/wpa_supplicant/wpa_supplicant.conf

network={

   ssid="xxx"

   psk="XXX"

   key_mgmt=WPA-PSK

   priority=5

}

network={

   ssid="yyy"

   psk="yyy"

   key_mgmt=WPA-PSK

   scan_ssid=1

   priority=3

}

network={

   ssid="zzz"

   key_mgmt=NONE

   priority=7

}

Disable service:

sudo update-rc.d boa disable

sudo apt update

sudo apt-get install apache2

/etc/apache2/mods-enabled

sudo ln -s ../mods-available/auth_basic.load

sudo ln -s ../mods-available/cgi.load

/etc/apache2/apache2.conf

<Directory "/usr/local/apache2/htdocs/somedir">

    Options +ExecCGI

</Directory>

AddHandler cgi-script .cgi .pl

/etc/apache2/sites-enabled/999-my.conf

<Location "/">

    AuthType basic

    AuthName "private area"

    AuthBasicProvider  file

    AuthUserFile    "/etc/apache2/password/htpasswd"

    Require            valid-user

</Location>

sudo systemctl restart apache2

sudo systemctl status apache2

virtual wlan interface

https://www.suse.com/c/creating-virtual-wlan-interfaces/

modprobe mac80211_hwsim

# wlan1 & wlan2 will be created

/etc/modules

mac80211_hwsim

* auto load

routed wireless access point

https://www.raspberrypi.org/documentation/configuration/wireless/access-point-routed.md

sudo apt install hostapd

sudo systemctl unmask hostapd

sudo systemctl enable hostapd

sudo apt install dnsmasq

sudo DEBIAN_FRONTEND=noninteractive apt install -y netfilter-persistent iptables-persistent

/etc/dhcpcd.conf

profile static_wlan0

static ip_address=192.168.4.1/24

interface wlan0

    env ifwireless=0

    fallback static_wlan0

    static ip_address=192.168.4.1/24

    nohook wpa_supplicant

* fix static ip/nohook not work

/etc/sysctl.d/routed-ap.conf

net.ipv4.ip_forward=1

sudo iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE

sudo netfilter-persistent save

sudo mv /etc/dnsmasq.conf /etc/dnsmasq.conf.orig

/etc/dnsmasq.conf

# Listening interface

interface=wlan0

dhcp-range=192.168.4.2,192.168.4.20,255.255.255.0,24h

# Pool of IP addresses served via DHCP

# Local wireless DNS domain

domain=wlan

address=/gw.wlan/192.168.4.1

# Alias for this router

sudo rfkill unblock wlan

/etc/hostapd/hostapd.conf

country_code=GB

interface=wlan0

ssid=NameOfNetwork

hw_mode=g

channel=7

macaddr_acl=0

auth_algs=1

ignore_broadcast_ssid=0

wpa=2

wpa_passphrase=AardvarkBadgerHedgehog

wpa_key_mgmt=WPA-PSK

wpa_pairwise=TKIP

rsn_pairwise=CCMP

*** dnsmasq make resolv.conf nameserver -> 127.0.0.1

resolvconf -i

resolvconf -d lo.dnsmasq

Captive Portal

https://captivebehavior.wballiance.com/

android:

http://connectivitycheck.gstatic.com/generate_204

ios:

http://captive.apple.com/hotspot-detect.html

mi:

http://connect.rom.miui.com/generate_204

http://developers.google.cn/generate_204

samsung:

?

Web Server:

ln -s index.html generate_204

ln -s index.html hotspot-detect.html

/etc/dnsmasq.conf

# ALL domain -> 192.168.4.243

address=/#/192.168.4.243

redirect any tcp port 80/443 from interface wlan0 to 192.168.4.243

iptables -t nat -I PREROUTING -i wlan0 -p tcp --dport 80 -j DNAT --to 192.168.4.243:80

iptables -t nat -I PREROUTING -i wlan0 -p tcp --dport 443 -j DNAT --to 192.168.4.243:443

Video player: OpenMAX H.264 GPU decode (pi 3 test youtube 1080@60) 

omxplayer

    -o both    audio 3.5mm & hdmi

    -o local    audio 3.5mm

    -o hdmi    audio hdmi

    -o alsa[:device]    bluetooth, etc

    --timeout 0    (fix m3u8 live stream stop)

    --win x1,y1,x2,y2    geometry

    --crop x1,y1,x2,y2

    --layer n    Set video render layer number (higher numbers are on top) (multi omxplayer)

web server: boa

sudo apt-get install boa

# add video/audio play permission to web cgi (user: www-data)

sudo usermod -a -G video www-data

sudo usermod -a -G audio www-data

/etc/boa/boa.conf

AddType application/x-httpd-cgi cgi

/etc/sudoers.d/power

# cgi to reboot/poweroff

www-data ALL = NOPASSWD:/sbin/reboot, /sbin/poweroff

sudo service boa start

Photo Viewer: feh

Launch bar logo

sudo cp xxx.png /usr/share/icons/PiX/16x16/places/rpi-logo.png

sudo cp xxx.png /usr/share/icons/PiX/24x24/places/rpi-logo.png

sudo cp xxx.png /usr/share/icons/PiX/32x32/places/rpi-logo.png

sudo cp xxx.png /usr/share/icons/PiX/48x48/places/rpi-logo.png

Raspberry logo

sudo cp yyy.png /usr/share/icons/hicolor/32x32/apps/rpi.png

sudo cp yyy.png /usr/share/icons/PiX/16x16/apps/rpi.png

sudo cp yyy.png /usr/share/icons/PiX/24x24/apps/rpi.png

sudo cp yyy.png /usr/share/icons/PiX/32x32/apps/rpi.png

sudo cp yyy.png /usr/share/icons/PiX/48x48/apps/rpi.png

/etc/rc.local not execute at first time power on

rc.local run before dependency service & got error

 -> check & wait for the service ready

systemctl list-units --no-pager

$ systemctl status rc.local

Warning: The unit file, source configuration file or drop-ins of rc-local.service changed on disk. Run 'systemctl daemon-reload' to reload units.

sudo systemctl daemon-reload

poweroff / reboot slow

/etc/systemd/system.conf

   DefaultTimeoutStopSec=5s

PUBG Mobile - OASIS FRESH All 46 Drinks Recipes 絕地求生 飲品配方

SSS	SFJ	SSC	SCC	JJC
SSF	SJC	SFC	JJJ	FJC
SSJ	SJJ	SFF	JJF	JFF
JCC	CCC	SSJ	SJJ	SFF
FFF	SSS	SFJ	SSC	SCC
FCC	SSF	SJC	SFC	JJJ
JJF	JFF	FCC	SSJ-I	JJC-I
JJC	JCC	CCC	SJJ-I	CCC-I
FJC	FFF	SSS-I	SCC-I	FFC
FFC

S	Syrup	蜂蜜	甜露
F	Flavoring	咖啡	苦酒
J	Sour Juice	檸檬汁	酸汁
C	Chili Sauce	辣椒	辣素
I	Ice	冰	冰
	Shake Gently	輕搖	轻摇
	Shake Quickly	快搖	快摇