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 -> Re: ORA-00903

Re: ORA-00903

From: Sashi <smalladi_at_gmail.com>
Date: Wed, 01 Aug 2007 08:31:55 -0700
Message-ID: <1185982315.070812.86700@22g2000hsm.googlegroups.com>


On Aug 1, 11:24 am, DA Morgan <damor..._at_psoug.org> wrote:
> SELECT owner, table_name
> FROM all_tables
> WHERE UPPER(table_name) = 'NED_PRODUCT_CARD';
>
> Who owns the table?
> Is the table name returned in upper case?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

OWNER                          TABLE_NAME
------------------------------ ------------------------------
NED                            NED_PRODUCT_CARD

That's the output for the select that you gave, Dan. I'm logged in as "ned".
Thanks,
Sashi Received on Wed Aug 01 2007 - 10:31:55 CDT

Original text of this message

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