Home » SQL & PL/SQL » Client Tools » Output alignment......
Output alignment...... [message #244852] Thu, 14 June 2007 06:14 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi All,

ttitle left report_date center "Permission Code report" right "Page" format 999 sql.pno

with the help of above code, i'm getting o/p like this:
example:
select sysdate from dual;

07/06/14 Permission Code report Page 1

SYSDATE
--------
20070614

but i want SYSDATE should come below Permission Code report or in other words o/p should be center align.
Is this possible?

Regards,
Dinesh
Re: Output alignment...... [message #244861 is a reply to message #244852] Thu, 14 June 2007 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ttitle center "Permission Code report" right "Page" format 999 sql.pno -
       skip -
       center report_date

Regards
Michel
Re: Output alignment...... [message #244871 is a reply to message #244852] Thu, 14 June 2007 07:10 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
example:
select 'Dinesh' from dual;

07/06/14 Permission Code report Page 1
'Dinesh'
---------
Dinesh

In above example, i want to print dinesh on the center not left align.

Re: Output alignment...... [message #244875 is a reply to message #244871] Thu, 14 June 2007 07:21 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Then you should use code tags.
Previous Topic: SQLPLUS not accessible
Next Topic: SQL+ login headache
Goto Forum:
  


Current Time: Tue Dec 06 12:22:44 CST 2016

Total time taken to generate the page: 0.14332 seconds