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) [...]
Entries Tagged as 'SQL*Plus'
Generating same column of a table with ascending order and descending order Simple query
July 26th, 2008 · 3 Comments
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 [...]
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) [...]
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 [...]
Tags: SQL*Plus