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 →

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 →

Create a website or blog at WordPress.com

Up ↑