Re: beginner needs help, now

If you're using SQL plus, type

Set lin 2000

This will put all of the data on one row, unless there are more than 2000 characters in your row. Then change 2000 to 3000 or higher until the data is on one row.

hth

Brian

Sarah Holley wrote:

> oracle users-
> i am a new user of oracle 8i with what seems to be a very basic
> question.
> i have a created a simply structured table that contains several lengthy
> character columns.
> instead of displaying the columns in one single horizontal line, oracle
> spills them over onto the next line.
> i would prefer that they were all on one line, letting me scroll right
> to read the table.
> how do i change a table so that all of my columns will appear in a
> single row across the top rather than in multiple rows?
> can this change be made when the table contains data?
>
> thank you very much for your help.
>
> candace miller
> * respond to:
> infinitesnail_at_hotmail.com
Received on Wed Nov 29 2000 - 08:50:14 CST