OracleBrains.Com header image 5

Entries Tagged as 'SQL*Plus'

Generating same column of a table with ascending order and descending order Simple query

July 26th, 2008 · 3 Comments

SELECT E1.EMPNO,E2.EMPNO FROM (SELECT ROWNUM r1,empno FROM emp ORDER BY empno DESC)e1,(SELECT ROWNUM r2,empno FROM emp ORDER BY empno ASC) [...]

[Read more →]

Tags: SQL and PL/SQL · SQL*Plus

SQL*PLUS DBMS_OUTPUT Now and Then

November 25th, 2007 · No Comments

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display [...]

[Read more →]

Tags: Oracle Administration · Oracle Database · SQL*Plus

HTML output from SQL*Plus

December 28th, 2006 · No Comments

This information for the guys who are new to SQL*Plus.
One can generate static HTML pages from SQL*Plus (8.1.6 and above) [...]

[Read more →]

Tags: SQL*Plus

Customizing SQL*Plus prompt

December 3rd, 2006 · No Comments

Today let me tell you about customization of SQL*Plus prompt. How we can use predefined variables to customize the SQL*Plus [...]

[Read more →]

Tags: SQL*Plus