dispaly the table row in a single line in oracle

Posted by Sheeba under ASP.NET on 4/5/2011 | Points: 10 | Views : 985 | Status : [Member] | Replies : 1
Hi


In oracle if i have a more than 5 columns ,oracle database does not show it in one line....But this makes confusion for beginners...how avoid this?

EX; table columns

NO NAME MARKS ADDRESS DESIG COUNTRY POSTAL PHONE ETC...

Oracle shows like that

NO NAME MARKS ADDRESS DESIG COUNTRY
---- ---------- ------------------------------ ---------- ---------- ----------
POSTAL PHONE
---------- ----------

it makes confusion....

How to avoid this?

Thanks in advance..




Responses

Posted by: Umeshdwivedi on: 4/17/2011 [Member] Starter | Points: 25

Up
0
Down
Hello
you check this link
http://www.dba-oracle.com/t_sql_output_one_line.htm

Latest Technology Trainer
And Part time software consultant

Sheeba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response