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

Home -> Community -> Usenet -> c.d.o.server -> Re: no rows returned on execution

Re: no rows returned on execution

From: Oleg Dimerman <olegd_at_e-mail.com>
Date: 1996/11/11
Message-ID: <328733AD.697E@e-mail.com>#1/1

dmarsha3 wrote:
> oracle is using user_tab_columns of y instead of x. Is there any way
> to get around apart from using dba_tab_columns.
> kramakri_at_dayton.csc.com

Use select field from all_tab_columns where owner = 'original owner';

-- 
____________________________________
Oleg Dimerman (olegd_at_e-mail.com)
Received on Mon Nov 11 1996 - 00:00:00 CST

Original text of this message

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