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: select qry - need an alternate way

Re: select qry - need an alternate way

From: Ashish <srivastava.ashish_at_gmail.com>
Date: 12 Jan 2006 02:43:28 -0800
Message-ID: <1137062608.736263.269080@g43g2000cwa.googlegroups.com>


Hi,

What exactly are you trying to achieve?
You can say
SELECT * from all_tables where table_name = 'EMP', but this wil give you the meta-data.
If you say Select * from EMP, this gives you the data(application specific) that resides IN the EMP table. Probably if you elaborate your need, we'll be able to help you better. Received on Thu Jan 12 2006 - 04:43:28 CST

Original text of this message

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