Re: SQLPLUS QUESTION

lan <lan_at_bluebird.com> wrote:

>Hi all,
 

>What command should I use to list database name and table names
>in SQLPLUS?
 

>thanks.
 

>--Lan

Hi,

   Here is a handy script to find out the relative tables in datadictionary.
rem --------- start of script
set feedback off
set pagesize 24
set verify off
col table_name format a30
col comments format a49
select * from dictionary
where table_name like upper('%&what%');
set pagesize 14
set verify on
set feedback on
rem ---------- end of script  

sample run

SQL> _at_what
Enter value for what: table

TABLE_NAME                     COMMENTS
------------------------------ -------------------------------------------------
ALL_TABLES                     Description of tables accessible to the user
DBA_TABLES                     Description of all tables in the database
DBA_TABLESPACES                Description of all tablespaces
USER_TABLES                    Description of the user's own tables
USER_TABLESPACES               Description of accessible tablespaces
TABLE_PRIVILEGES               Grants on objects for which the user is the grant
                               or, grantee, owner,
                                or an enabled role or PUBLIC is the grantee

V$FIXED_TABLE                  Synonym for V_$FIXED_TABLE