_______ _______ _______ ___ _______
| || || || | | |
|_ _|| _ || _ || | | _____|
| | | | | || | | || | | |_____
| | | |_| || |_| || |___ |_____ |
| | | || || | _____| |
|___| |_______||_______||_______||_______|
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
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 |
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
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 /> |
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
# 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>"}' |
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
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', |
Source: https://docs.oracle.com/javase/8/docs/api/java/lang/Thread.State.html
Thread state for a thread blocked waiting for a monitor lock.
Thread state for a thread which has not yet started.
Thread state for a runnable thread.
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
-- http://www.thatjeffsmith.com/archive/2012/05/enabling-dbms_output-by-default-in-sql-developer/ | |
SET SERVEROUTPUT ON |
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
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; |
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
class NodePrinter{ | |
private String filePath | |
private String namespacePrefix | |
NodePrinter(String filePath, String namespacePrefix){ | |
this.filePath = filePath | |
this.namespacePrefix = namespacePrefix | |
} |