Linux mkdir -p for make subdirecotry recursive

 mkdir -p jp/co/test/app/logic/kino001

Oracle Export SEQUENCE source

select

'DROP SEQUENCE ' || seq.SEQUENCE_OWNER || '.' || seq.SEQUENCE_NAME || ';'  DSQL,

'CREATE SEQUENCE ' || seq.SEQUENCE_OWNER || '.' || seq.SEQUENCE_NAME 

|| ' INCREMENT BY 1 ' 

|| ' START WITH ' || seq.LAST_NUMBER 

|| ' MINVALUE ' || seq.MIN_VALUE

|| ' MAXVALUE ' || seq.MAX_VALUE 

|| '  ' || CASE seq.CYCLE_FLAG WHEN 'Y' THEN 'CYCLE' ELSE 'NOCYCLE' END

|| '  ' || CASE seq.ORDER_FLAG WHEN 'Y' THEN 'ORDER' ELSE 'NOORDER' END

|| '  ' || CASE seq.CACHE_SIZE WHEN 0 THEN 'NOCACHE' ELSE 'CACHE ' || seq.CACHE_SIZE  END || ' ; '  CSQL, 

 seq.* 

from ALL_SEQUENCES seq

where  SEQUENCE_OWNER IN('SYS', 'SYSTEM')

order by SEQUENCE_OWNER

PowerShell foreach unzip files

$zipfolder="C:\zipfolder"
$zipfiles=get-childitem -path $zipfolder -name "*.zip"
foreach($f in $zipfiles)
{
  #-f  --force  
  Expand-Archive -Path "$zipfolder\$f" -DestinationPath "$zipfolder"  -f
}

Oracle SYNONYMS

SELECT * FROM USER_SYNONYMS WHERE SYNONYM_NAME = 'syn_name';  -- User synonyms
SELECT * FROM ALL_SYNONYMS WHERE TABLE_OWNER = 'JINJI';	  -- Available to user
SELECT * FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'schema_name'; -- All schemas

SELECT 
  'CREATE OR REPLACE EDITIONABLE PUBLIC SYNONYM "' || SYNONYM_NAME 
  || '" FOR "' || SYNONYM_NAME || '"@' ||  TABLE_OWNER || '.' || DBLINK_NAME || ';' SQL 
FROM ALL_SYNONYMS WHERE TABLE_OWNER = 'SCHEMA_NAME';