Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Show Owner of Table
I'm user "BLAH"
table "emp" belongs to "scott"
I define a synonym "emp" for scott.emp
When SELECTing from "emp" -
blah_at_dev> SELECT * FROM emp ;
How can I show the owner of the table ("scott") ?
thanks
10gR2 Received on Wed Jan 24 2007 - 11:17:59 CST