Home » SQL & PL/SQL » SQL & PL/SQL » change column alignment
change column alignment [message #269377] Fri, 21 September 2007 20:20 Go to next message
avittam
Messages: 1
Registered: August 2007
Junior Member
Hi!

Is it possible to modify column id attribute of a column?

If not change column id, can the alignment of the column be done?

I don't jus want to view the columns as I wish I want the column alignment to be changed for eg. can the first to column be shifted to the last or in the middle somewhere in the table?

Re: change column alignment [message #269378 is a reply to message #269377] Fri, 21 September 2007 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
If you insist in such meaningless nonsense, then create a view.
The order of the columns in a table is totally irrelevant to any properly implemented application.
Re: change column alignment [message #269396 is a reply to message #269377] Sat, 22 September 2007 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change the column order in your select statement.

Regards
Michel
Re: change column alignment [message #269497 is a reply to message #269377] Sun, 23 September 2007 00:30 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
Still not able to understand your question?
Explain with practical example.

In SQL reports there is a option called
COLUMN <COL NAME> JUSTIFY LEFT RIGHT CENTER.
Re: change column alignment [message #269498 is a reply to message #269396] Sun, 23 September 2007 00:31 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
uSING
oRDER BY COLNAME1,COLNAME2 OR
ORDER BY 1,4,2 ETC.
Re: change column alignment [message #269499 is a reply to message #269497] Sun, 23 September 2007 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
srikanthvijay8,
JUSTIFY option of COLUMN command only justifies the column heading not the values.

Regards
Michel
Re: change column alignment [message #269500 is a reply to message #269499] Sun, 23 September 2007 00:44 Go to previous messageGo to next message
srikanthvijay8
Messages: 16
Registered: July 2007
Location: Chennai pattanam
Junior Member
Inside sql you can use lpad and rpad functions.
Re: change column alignment [message #269529 is a reply to message #269500] Sun, 23 September 2007 01:32 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
srikanthvijay8,
I don't think this is OP's purpose. I think he meant "column order" when he said "column alignment"; see the example at the end of the sentence.

Regards
Micehl
Previous Topic: UTL_FILE in PL/SQl block
Next Topic: Drop All Tables For A User
Goto Forum:
  


Current Time: Fri Dec 02 18:42:43 CST 2016

Total time taken to generate the page: 0.19348 seconds