Mujahid Khaleel mujahidk
mujahidk
/ oracle-json-table-example.sql
Last active
May 3, 2018 12:55
Oracle 12c JSON_VALUE and JSON_TABLE example.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- JSON_VALUE example | |
| SELECT | |
| JSON_VALUE(request,'$.phone.typeId' RETURNING NUMBER) | |
| FROM | |
| web_requests; | |
| -- JSON_TABLE example | |
| SELECT | |
| * | |
| FROM |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import java.lang.management.ManagementFactory | |
| println "Process ID: " + ManagementFactory.getRuntimeMXBean().getName() | |
| println "Uptime: " + ManagementFactory.getRuntimeMXBean().getUptime() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| syntax on | |
| cmap w!! w !sudo tee % >/dev/null |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| find -type f -name 'dsc*'| awk '{gsub(".xyz","",$1);system("mv "$1".xyz "$1".jpg")}' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PS1="\n\[\033[01;32m\]\u\[\033[00;35m\]@\h \[\033[00;33m\]\w \[\033[0m\]\n\$ " | |
| EXPORT PS1 |
mujahidk
/ vb-mount-host-folder.sh
Created
December 22, 2017 23:58
VirtualBox - Mount host shared folder in Linux guest.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # VirtaulBox --> Select machine --> Settings --> Shared Folders + Machine Folders (Name: centos-ui) | |
| cd | |
| mkdir shared | |
| sudo mount -t vboxsf centos-ui ~/shared/ |
mujahidk
/ base64coding.groovy
Created
December 22, 2017 23:40
Base64 encoding and decoding in Groovy.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def text = "Going to convert this to Base64 encoding!" | |
| // Encode | |
| def encoded = text.bytes.encodeBase64().toString() | |
| println encoded | |
| // Decode | |
| byte[] decoded = encoded.decodeBase64() | |
| println new String(decoded) |
mujahidk
/ increase-vm-disk-size.bat
Created
December 20, 2017 18:59
Increase VirtualBox disk partition size.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| VBoxManage modifyhd "C:\vms\centos-ui\centos-ui.vdi" --resize 12288 |