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: Retrieving table name

Re: Retrieving table name

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 18 Jun 2002 13:00:12 +0200
Message-ID: <3D0F12BC.7C61FDC7@mytoys.de> 





Noemie FB wrote:



> I would like to retrieve all tables containing a column named "status".

> How can I do that ?




select TABLE_NAME from <user_tab_columns|all_tab_columns> where
COLUMN_NAME='STATUS';


Regards,



Knut
Received on Tue Jun 18 2002 - 06:00:12 CDT












Original text of this message













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