Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> what is this sqlplus output?

what is this sqlplus output?

From: Martin Meadows <mmeadows_at_indy.net>
Date: Wed, 22 Apr 1998 22:18:34 -0500
Message-ID: <353EB30A.1EE2@indy.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US