SQL

listagg()

admin / 2024-11-04

Today I needed to create an audit statement with a lot of users who are excepted from auditing. It looks […]

admin / 2024-03-23

Distribution of data For calculating the right execution-plan Oracle often needs the distribution of values for a column. For an […]

admin / 2024-01-19

A very simple example of creating an ACL for a principal and a host: Creating the ACLS (qith the associated […]

admin / 2022-02-22

Index Why In the DB2 : Cost Calculation 2 : index only post I noticed something upsetting, well, at least […]

admin / 2022-02-05

Sometimes you need a mechanism to generate rows. For example when you need to create a demonstration table . Recursive […]

admin / 2022-01-09

Every time I install a new oracle machine it hits me: Why is login.sql not executed when I start a […]

admin / 2021-04-25

Problem Playing around in DB2 I wanted to know how to create a hiearchical query. This because I wanted to […]

admin / 2021-01-18

You can have a look at v$sesstat (joined with v$staname) to see the value of some statistics at this moment. […]