Re: what is this sqlplus output?

Simple. Your query results are wrapping. Upon opening sqlplus, you need to reset the 'linesize' option. The default is 100 characters per line. Before issuing your query, set it to 100 chars by typing the command:

set linesize 1000

Re-issue your query. The result set should now span horizontally for 100 characters and you can simply scroll right. What you're currently seeing is a mish-mash of column names, header separators (the rows of hyphens) and your actual query results, all wrapping so that they don't line up vertically in an intuitive way. A wider linesize should fix it.

If you're running a 'window'ed version of sqlplus (as opposed to the sqlplus command line in UNIX, you should have an option menu where you can set many environment variables in addition to linesize. In either 'window'ed or command line sqlplus, the 'set' command followed by the environment variable name and desired value (e.g. 'set linesize 1000') will accomplish the same thing as setting your options through the 'Options' menu. Just keep in mind that each environment variable you change through the options menu should be followed by a click of 'OK' before re-opening 'Options' and setting another variable. In other words, you can't change more than one setting at a shot.

Peace,
-Brendan

In article <353EB30A.1EE2_at_indy.net>,
  mmeadows_at_indy.net wrote:

>
> I just ran a command in sqlplus that produced output I don't understand.
> Can someone please explain it?
>
> SQL> SELECT * FROM ALL_SYNONYMS
> 2 WHERE SYNONYM_NAME = 'PAYROLL_TRANSACTION_DETAIL';
>
> OWNER
> SYNONYM_NAME
> ------------------------------
> ------------------------------
> TABLE_OWNER
> TABLE_NAME
> ------------------------------
> ------------------------------
> DB_LINK

> ----------------------------------------------------------------------
> PUBLIC
> PAYROLL_TRANSACTION_DETAIL
> OPS$KTCO
> KTCOPROD_PAYROLL_TRANS_DETL
>
> OPS$PROFOUND
> PAYROLL_TRANSACTION_DETAIL
> OPS$PROFOUND
> KTCOPROD_PAYROLL_TRANS_DETL
>
> OWNER
> SYNONYM_NAME
> ------------------------------
> ------------------------------
> TABLE_OWNER
> TABLE_NAME
> ------------------------------
> ------------------------------
> DB_LINK

> ----------------------------------------------------------------------
>
> Thanks,
> Martin Meadows
> Indianapolis, In.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 24 1998 - 10:58:57 CDT