Wednesday, November 3, 2021

An Oracle procedure that allow users to kill their own sessions

›
First, create a view that lets the users check their own sessions: connect / as sysdba create or replace view my_sessions as select us...
Friday, October 29, 2021

How to exctract a specific file from a .tar file

›
Say I would like to extract an old version of the oracle inventory, packed in a tar file called "oracle.tar". Change directory t...
Tuesday, October 26, 2021

How to only insert rows that do not violate a specific constraint

›
PostgreSQL offers an alternative to raising an exception upon a unique key violation: ON CONFLICT ON CONSTRAINT INSERT INTO sales.sales_h...
Monday, October 18, 2021

How to export a single table in PostgreSQL

›
Example of exporting a single table. In the directory-format: pg_dump -Fd mydb -t myschema.mytable -v -f /data/mydirectory -j 2 Where...
Friday, October 15, 2021

How to list the number of rows per partition in PostgreSQL

›
I found an old post from 2013 on stackoverflow.com which solved a problem I had finding the number of rows per partition in PostgreSQL. ...
Tuesday, October 12, 2021

In PostgreSQL, what does "regclass" mean?

›
"regclass" is an alias for an Object Identifier, which are used internally by PostgreSQL as primary keys for several data dictio...
Thursday, September 30, 2021

How to rename a database to use lower case instead of upper case characters

›
At my customer's site, we have standardized the Oracle SIDs (System ID) to use lower case character. During an upgrade, the SID was ...