2024-12-04

Java optional

›
Optional<String> o; o = Optional.empty(); o.ifPresentOrElse(System.out::println, () -> System.out.println(...
2024-07-25

Database move objects

›
WITH DATA AS ( SELECT USER owner, segment_name, segment_type, SEGMENT_SUBTYPE, SUM(bytes)/1024/1024/1024 FROM user_segments s GR...
2022-12-05

Powershell: docker - print tags for image

›
$imageName='camunda/camunda-bpm-platform' $nextLink="https://registry.hub.docker.com/v2/repositories/$imageName/tags" echo...
2022-11-25

Spring enum properties possible values

›
From this reply RelaxedDataBinder#bind() RelaxedConversionService#convert() 1. try DefaultConvertionService#convert() # only...
2022-08-26

Oracle 19c: JSON and character sets

›
Given Oracle 19c in WE8MSWIN1252 charset. Processing the JSON in UTF-8 using different functions. Test DECLARE c_json_utf8 VARCHAR2(3...
2022-06-14

Extract information about deadlocks from traces

›
If you don’t have access to filesystem or love to do everything in SQL here is the quick and dirty solution how to extract information about...
2022-06-08

Powershell: basic listener

›
Found here $Listener = [System.Net.Sockets.TcpListener]8080; $Listener.Start(); $Listener.AcceptSocket();
2022-05-09

Jenkins: print password

›
stage('Sandbox') { withCredentials([usernamePassword(credentialsId: 'TestUser', passwordVariable: 'C_PASS', usernam...
2022-05-02

GIT: Run the changes from current branch

›
Run the difference between the current feature branch and target branch (configured to dev) to which the feature branches are merged in the ...
2022-03-24

Print JSON attributes names and types

›
Script to traverse and print types (except one with null values) and change values to attribute names (useful for testing purposes) DECLARE...
2021-12-17

Generate queries for PK-FK data check

›
Given: table to be inspected l_owner l_table_name row in this table l_table_condition Result: generated queries to extract parent r...
2021-11-24

DB Link creation with direct insert

›
insert into sys.link$ (OWNER#, NAME, CTIME, HOST, USERID, PASSWORD, FLAG, AUTHUSR, AUTHPWD, PASSWORDX, AUTHPWDX) SELECT user_id ,'DB_L...
2021-11-08

Async using dbms_scheduler package

›
Simple async procession in Oracle can be implemented with dbms_scheduler package -- dbms_scheduler.create_job makes explicit commit!!! dbms...
2021-10-29

All privileges for all users

›
-- You can filter results in last lines of query WITH all_user_roles AS ( SELECT DISTINCT connect_by_root(grantee) username, granted_ro...
2021-06-21

GIT housekeeping

›
Remove branches not present in remote script from stackoverflow: git checkout master; git remote update origin --prune; git branch -vv | Se...
2021-05-10

CONVERT for UTF-8

›
CONVERT function for clob input parameter in database with WE8MSWIN1252 character does not convert to UTF-8 - result is looking like UTF-16...
2021-04-08

Jenkins: print script executed by sh

›
Put inside the script. Print to trace find /var/jenkins_home/jobs/My_Job/workspace@tmp/ \\ -name 'script.sh' \\ -exec cat ...
2021-04-07

Character set conversion

›
Based on this db1>SELECT value FROM nls_database_parameters WHERE parameter='NLS_CHARACTERSET'; VALUE -------------------------...
2021-04-02

Jenkins: fire on change of specific file in specific branch in Bitbucket

›
Jenkins: fire on change of specific file in specific branch in Bitbucket Perhaps different set of plugins can execute t...
2021-03-24

Find all utl_ packages in source code

›
Using grep utility grep -rohP "(^|\W)\Kutl_\w*\." . | sort -u