Re: beginner needs help, now

Hi

There are a number of ways you can achieve your desired result.

You appear to have confused the display of data from an Oracle table, with the storage of data in that table. It is the displaying application, which you do not specify, which is giving you the results you see. Not the Oracle server software. It follows from this that you need to configure thjis display application to show the results you want, or choose another display application.

Assuming that you are using sqlplus (which is the most likely given your problem description) the command that you need to issue is set linesize x (where x is the length of the line in characters). In 8i x can be up to 32767 (32k).

Alternatively if you are a windows bod then you can use an ODBC compliant application and connect to your datasource through that. Primne canditates for this would be Access or if less money is available excel.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Sarah Holley" <i4is_at_pacbell.net> wrote in message
news:3A245AF0.ADE1208_at_pacbell.net...


> 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

>