SQL*Plus Tricks Vol 2

In my post "SQL*Plus Tricks Vol 1" I mentioned the feature to edit your last SQL command using your preferred editor. Here is another possibility. Trick 5 (see trick 1 to 4 in my previous post "SQL*Plus Tricks Vol 1") You can modify a specific line in your last sql command without using an editor. SQL> l... Continue Reading →

SQL*Plus Tricks Vol 1

SQL*Plus, some love it, some hate it. Let's focus on what SQL*Plus can do and leave the disadvantages aside for now. Here are some of my top tricks to get more out of SQL*Plus. Before getting into the subject, let's have a look at SQL*Plus' help command: SQL> help index Enter Help [topic] for help.... Continue Reading →

Generate Values in Oracle SQL

I just came across an awesome SQL which I wanted to share with you. This is a SQL query which generates a sequence of values. I often need this when generating "0" (zero) values for graphs. SQL> SELECT level FROM dual CONNECT BY level <= 7;      LEVEL ---------- 1 2 3 4 5 6... Continue Reading →

Killing Sessions in Oracle

There are many reasons why a dba has to kill a session. That is pretty ease but not always successful. But why it is not always successful? An alter system kill session '<SID>,<SERIAL#>'; may not kill the session because that's not what the commands does. The command sets a flag in the session which will... Continue Reading →

Create a website or blog at WordPress.com

Up ↑