Skip to content

Instantly share code, notes, and snippets.

@mujahidk
mujahidk / oracle-random-string.sql
Created December 12, 2017 21:53
Oracle random numbers and strings.
select 1 as SERIAL, 'Random value (0-1)' as RANDOM_TYPE, dbms_random.value||'' as VALUE from dual
union
select 2, 'Random value (1, 1K)', dbms_random.value(1,1000) ||'' from dual
union
select 3, 'UPPER CASE', dbms_random.string('U', 25) from dual
union
select 4, 'lower case', dbms_random.string('L', 25) from dual
union
select 5, 'MiXEd CaSE', dbms_random.string('A', 25) from dual
union
@mujahidk
mujahidk / sample-test-file.txt
Last active November 29, 2017 19:47
Generate CLOB text PL/SQL block from a text file.
Line with single' quote.
Line with multiple single ''' quotes.
Below is are two(2) empty lines.
Below are two empty lines with spaces and tabs.
This line has "double quotes".
This line <b>has html</b> text in it.<br />
@mujahidk
mujahidk / mvn-dep-markdown-html.sh
Last active November 16, 2017 16:02
Maven dependencies in markdown and html table format.
# Markdown
mvn dependency:list -Dsort | grep -oP 'com.mujahidk.*' | awk -F":" 'BEGIN {print "|Package|Group|Type|Version|\n|--|--|--|--|"}{ print "|" $1 "|" $2 "|" $3 "|" $4 "|" }'
# HTML table
mvn dependency:list -Dsort | grep -oP 'com.mujahidk.*' | uniq | awk -F":" 'BEGIN {print "<table><tr><th>Package</th><th>Group</th><th>Type</th><th>Version</th><tr>"}{ print "<tr><td>" $1 "</td><td>" $2 "</td><td>" $3 "</td><td >" $4 "</td></tr>" }END {print "</table>"}'
@mujahidk
mujahidk / oracle-package-info.sql
Created November 13, 2017 16:23
Oracle packages and access info.
SELECT DISTINCT Owner,
Object_Type,
Object_Name
FROM DBA_Objects_AE
WHERE Owner IN (
'SYS','OUTLN','SYSTEM','CTXSYS','DBSNMP',
'LOGSTDBY_ADMINISTRATOR','ORDSYS','ORDPLUGINS',
'OEM_MONITOR','WKSYS','WKPROXY','WK_TEST',
'WKUSER','MDSYS','LBACSYS','DMSYS','WMSYS',
'OLAPDBA','OLAPSVR','OLAP_USER','OLAPSYS',
@mujahidk
mujahidk / tools-and-extensions.md
Last active July 16, 2018 14:31
Tools, extensions and plugins.

Tools and Extensions

  _______  _______  _______  ___      _______ 
|       ||       ||       ||   |    |       |
|_     _||   _   ||   _   ||   |    |  _____|
  |   |  |  | |  ||  | |  ||   |    | |_____ 
  |   |  |  |_|  ||  |_|  ||   |___ |_____  |
  |   |  |       ||       ||       | _____| |
  |___|  |_______||_______||_______||_______|
@mujahidk
mujahidk / issues-and-related-information.md
Last active November 13, 2017 00:51
General issues and related information
@mujahidk
mujahidk / java-threads-info.md
Created October 25, 2017 20:39
Quick java thread state information.
@mujahidk
mujahidk / sql-developer-startup.sql
Created October 24, 2017 15:32
SQL Developer startup script.
-- http://www.thatjeffsmith.com/archive/2012/05/enabling-dbms_output-by-default-in-sql-developer/
SET SERVEROUTPUT ON
@mujahidk
mujahidk / table-dependencies.sql
Created September 29, 2017 13:09
Oracle table dependencies.
SELECT REFERENCED_NAME, NAME, TYPE
FROM SYS.ALL_DEPENDENCIES
WHERE REFERENCED_TYPE='TABLE'
AND OWNER ='<<SCHEMA_NAME>>'
AND REFERENCED_NAME IN('<<TABLE1>>', '<<TABLE2>>')
ORDER BY REFERENCED_NAME, TYPE;
@mujahidk
mujahidk / print-xml-tree-nodes.groovy
Last active September 14, 2017 14:46
Print xml node names in basic XPath format.
class NodePrinter{
private String filePath
private String namespacePrefix
NodePrinter(String filePath, String namespacePrefix){
this.filePath = filePath
this.namespacePrefix = namespacePrefix
}