Re: Creating a Group Of Tables

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 18 Dec 2001 23:02:40 -0800
Message-ID: <a8aed4.0112182302.4f0933d3@posting.google.com>

girish_bhat_at_yahoo.com (Girish) wrote in message news:<2dc1bfd.0112180625.5d51d7d3_at_posting.google.com>...
> Hi,
> Ive got many modules in my application.I would like to identify the
> tables related to the specific module in a single query.How can i
> segregate them without creating them under multiple schemas?Is there
> any way by which i can place a comment in the table while creating it.
> I hope im clear with my problem.
>
> Girish

Not Unless u have followed some Naming Methdology ... Comments are there but it will be a Bit Tedious.

What u will have to do is to ...

Comment on Table emp is 'ProjectName-Employee Master'

then use this Query to get the Table Names...

select table_name from dba_tab_comments where CommentS like 'ProjectName-%';

HTH Regards,
Ganesh R Received on Wed Dec 19 2001 - 01:02:40 CST