FREE GUI tool http://www.websoft.com.au/downloads.html
Date: Fri, 11 Jan 2002 11:25:06 +1100
Message-ID: <3C3E30E2.68106D3E_at_websoft.com.au>
Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
If its only "tables" you are after then: select table_name from all_tables where owner =<SCHEMA_NAME> If you later require other objects (eg. views,functions,procedures,triggers etc). then use select owner,object_type,object_name from all_objects where owner = <SCHEMA_NAME>
Also you can Download FREE a GUI tool called Platypus from http://www.websoft.com.au/downloads.html helps you manage/develop across many oracle databases/schemas simultaneously without typing in any sql:
* Create/Drop tables,indexes,primary key,views,triggers etc * Monitor users connected to oracle databases * Monitor/Add/Drop Users,Tablespaces,Datafiles
For those who like typing in sql it also includes: * SQL Windows with all results displayed in a spreadsheet style user interface. * SQL Scripts to run/save your batch files.
Philip Morrow wrote:
> What code can I run to determine if a table say 'tablea' exists in a schema > > Thanks > Phil --------------2916DF7D07EE0ABEE950B590
Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
If its only "tables" you are after then:
<br><b>select table_name from all_tables where owner =<SCHEMA_NAME></b>
<br>If you later require other objects (eg. views,functions,procedures,triggers
etc). then use
<br><b>select owner,object_type,object_name from all_objects where owner
= <SCHEMA_NAME></b>
<p>Also you can Download <b>FREE</b> a GUI tool called <b>Platypus</b>
<br>from <A HREF="http://www.websoft.com.au/downloads.html">http://www.websoft.com.au/downloads.html</A>
<br>helps you manage/develop across many oracle databases/schemas simultaneously
<b>without typing in any sql:</b>
<br>* Create/Drop tables,indexes,primary key,views,triggers etc
<br>* Monitor users connected to oracle databases
<br>* Monitor/Add/Drop Users,Tablespaces,Datafiles
<p>For those who like typing in sql it also includes:
<br>* SQL Windows with all results displayed in a spreadsheet style user
interface.
<br>* SQL Scripts to run/save your batch files.
<p>Philip Morrow wrote:
<blockquote TYPE=CITE>What code can I run to determine if a table say 'tablea'
exists in a schema
<p>Thanks
<br>Phil</blockquote>
</html>
--------------2916DF7D07EE0ABEE950B590-- Received on Fri Jan 11 2002 - 01:25:06 CET