All gists - Opengist

stuzer05 / Oracle list jobs

Last active 3 months ago

0 0 1

1	select owner as schema_name,
2	job_name,
3	job_style,
4	case when job_type is null
5	then 'PROGRAM'
6	else job_type end as job_type,
7	case when job_type is null
8	then program_name
9	else job_action end as job_action,
10	start_date,

stuzer05 / Postgres upgrade major version

Last active 3 months ago

https://github.com/docker-library/postgres/issues/37#issuecomment-180615524

0 0 1

1	docker exec postgres-old pg_dumpall -U root \| docker exec -i postgres-new psql -U root

stuzer05 / Docker prune volumes --dry-run

Last active 3 months ago

0 0 1

1	docker volume ls --filter dangling=true

stuzer05 / PHP show errors

Last active 3 months ago

0 0 1

1	ini_set('display_errors', '1');
2	ini_set('display_startup_errors', '1');
3	error_reporting(E_ALL);

stuzer05 / Docker inspect to run converter

Last active 3 months ago

`docker inspect` template to regenerate the `docker run` command that created a container, https://gist.github.com/efrecon/8ce9c75d518b6eb863f667442d7bc679, docker inspect --format "$(curl -s https://gist.stuzer.link/stuzer05/fdfc31107ce04720a186d409498e82f2/raw/HEAD/run.tpl)" 55a319b7e124

0 0 1

1	docker run \
2	--name {{printf "%q" .Name}} \
3	{{- with .HostConfig}}
4	{{- if .Privileged}}
5	--privileged \
6	{{- end}}
7	{{- if .AutoRemove}}
8	--rm \
9	{{- end}}
10	{{- if .Runtime}}

stuzer05 / Decode HeidiSQL export password

Last active 3 months ago

0 0 1

1	function heidiDecode(hex) {
2	var str = '';
3	var shift = parseInt(hex.substr(-1));
4	hex = hex.substr(0, hex.length - 1);
5	for (var i = 0; i < hex.length; i += 2)
6	str += String.fromCharCode(parseInt(hex.substr(i, 2), 16) - shift);
7	return str;
8	}
9	document.write(heidiDecode('755A5A585C3D8141786B3C385E3A393'));

stuzer05 / Oracle search source code in functions DDL

Last active 3 months ago

1 0 1

1	SELECT
2	type,
3	name,
4	text
5	FROM
6	all_source
7	WHERE
8	type IN ( 'FUNCTION', 'PROCEDURE' )
9	AND UPPER(text) like UPPER('%EI_KURS_VAL%')
10	ORDER BY type, name

stuzer05 / Go context.WithCancel() example

Last active 3 months ago

0 0 1

1	func doWork(ctx context.Context) {
2	for {
3	select {
4	case <-ctx.Done():
5	return
6	default:
7	}
8
9	time.Sleep(1 * time.Second)
10	fmt.Println("doing work...")

stuzer05 / Oracle view locked tables

Last active 3 months ago

0 0 1

1	SELECT o.object_name, o.object_type, l.session_id, l.locked_mode
2	FROM v$locked_object l
3	JOIN dba_objects o ON l.object_id = o.object_id;

stuzer05 / Nginx default vhost configuration

Last active 3 months ago

0 0 1

1	http {
2
3	server {
4	listen 80 default_server;
5	server_name _;
6
7	return 404;
8	}
9