Re: what is this sqlplus output?

Martin,

I don't see where you ever got any answers on this, but hopefully someone sent you a response directly. If not, you're running into the problem of trying to fit too much information based upon what your linesize is set to. Increase your linesize and/or format the columns you are selecting to fit within your established linesize.

Good luck.

--brad

Martin Meadows 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.
Received on Mon Apr 27 1998 - 10:33:25 CDT