Re: HELP !!!! Simple problem...

you can also force column format, make stuff line up better (eg, in 80 cols)... for any field in your select you want to trim, do something like this:

column sid heading "SID" format 9999999 column owner heading "Owner" format a15 column object heading "Object" format a25 column type heading "Type" format a25

select sid,
owner,
object,
type
from v$access
order by 1, 2, 3, 4;

• get it? that will help keep your displays on the screen...

brent

>columns across.
>The problem seems to be in the display of the data.
>Example: A select statement (select * from <table>;) displays only
>six columns (even when I scroll to the extreme right!! Now I know these
>columns exist because a describe statement defines the table exactly.
>Also a select statement calling for the extreme right columns displays
>them correctly.
Received on Thu Jul 22 1999 - 08:23:44 CDT