From oracle-l-bounce@freelists.org Mon Mar 28 15:44:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2SLipsn032130 for ; Mon, 28 Mar 2005 15:44:51 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2SLipem032126 for ; Mon, 28 Mar 2005 15:44:51 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D98BB895F1; Mon, 28 Mar 2005 15:42:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29089-01; Mon, 28 Mar 2005 15:42:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40DE88958D; Mon, 28 Mar 2005 15:42:57 -0500 (EST) Message-ID: <5E927FAE154F7A4FB83E49E1139F137F06AAE8FD@ussccem04.hds.com> From: "Graeme St. Clair" To: oracle-l@freelists.org Subject: RE: DESCRIBE? Date: Mon, 28 Mar 2005 12:41:02 -0800 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 17744 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Graeme.St.Clair@hds.com Precedence: normal Reply-To: Graeme.St.Clair@hds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=AWL,SUBJ_ALL_CAPS autolearn=no version=2.60 X-Spam-Level: And it turns out that what I really wanted was:- Select * from user_tab_columns where table_name = 'my_data_base' Rgds, GStC. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 2:38 PM To: oracle-l@freelists.org Subject: RE: DESCRIBE? Thanks to all responders, particularly Jonathan. The first para of his first citation is:- QUOTE You've just taken on responsibility for a new database. New to you, that is -- the database has actually been running for some years. What's the first thing you want to do? If you're like me, you probably want to get a handle on just what it is that you have. What's in the database? How big is it? Who are the users and how many of them are there? The answers to all of these questions lie in the Oracle data dictionary. UNQUOTE How truly deeply true... Tx & rgds, GStC. -- http://www.freelists.org/webpage/oracle-l