Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> what is this sqlplus output?
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 Wed Apr 22 1998 - 22:18:34 CDT
![]() |
![]() |