Re: what is this sqlplus output?

Hi Martin,

When you execute a SELECT * FROM ALL_SYNONYMS, be prepared to get * from all_synonyms ! ;-)

Frank

Martin Meadows <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.
Received on Thu Apr 23 1998 - 07:15:46 CDT