desc all_col_comments;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 COLUMN_NAME                               NOT NULL VARCHAR2(30)
 COMMENTS                                           VARCHAR2(4000)

desc CONFS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ACONF                                     NOT NULL VARCHAR2(15)
 NCONF                                     NOT NULL VARCHAR2(150)
 LOCAT                                     NOT NULL VARCHAR2(150)
 ST_DATE                                   NOT NULL DATE
 END_DATE                                  NOT NULL DATE
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 URL                                                VARCHAR2(150)
 LPROC                                              VARCHAR2(3)
 REG_DEAD                                           DATE
 ABS_DEAD                                           DATE
 SUB_DEAD                                           DATE
 O_DEAD                                             DATE
 O_DESC                                             VARCHAR2(150)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

desc INSTITS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 INSTITUTE                                 NOT NULL VARCHAR2(150)
 AINST                                              VARCHAR2(15)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 CONTACT                                            VARCHAR2(100)
 PHONE                                              VARCHAR2(80)
 FAX                                                VARCHAR2(80)
 VIDEOPHONE                                         VARCHAR2(80)
 HOMEPAGE                                           VARCHAR2(150)
 ADDR                                               VARCHAR2(300)
 STATUS                                             VARCHAR2(10)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

desc LINKS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID_LINK                                   NOT NULL NUMBER(38)
 ANAME                                     NOT NULL VARCHAR2(25)
 ACONF                                     NOT NULL VARCHAR2(15)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 TOPIC                                     NOT NULL VARCHAR2(150)
 TGROUP                                    NOT NULL VARCHAR2(15)
 PROC_URL                                           VARCHAR2(150)
 TRANS_URL                                          VARCHAR2(150)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

desc MASTINSTS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 AINST                                     NOT NULL VARCHAR2(15)
 NINST                                     NOT NULL VARCHAR2(150)
 STATUS                                    NOT NULL VARCHAR2(10)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

desc PEOPLES
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ANAME                                     NOT NULL VARCHAR2(25)
 STATUS                                    NOT NULL VARCHAR2(10)
 AINST                                     NOT NULL VARCHAR2(15)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 NAME                                               VARCHAR2(50)
 LTALK                                              VARCHAR2(3)
 JOB_RANK                                           VARCHAR2(20)
 JOB_STATUS                                         VARCHAR2(150)
 SERVICE_D0EXP                                      VARCHAR2(2000)
 SERVICE_GROUP                                      VARCHAR2(2000)
 PREFERENCES                                        VARCHAR2(150)
 EBOARDS                                            VARCHAR2(300)
 OGROUPS                                            VARCHAR2(300)
 ST_DATE                                            DATE
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

SQL> desc PGROUPS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PGROUP                                    NOT NULL VARCHAR2(10)
 PG_DESC                                   NOT NULL VARCHAR2(150)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

SQL> desc SSGROUPS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SSGROUP                                   NOT NULL VARCHAR2(15)
 SSG_DESC                                  NOT NULL VARCHAR2(50)
 SGROUP                                    NOT NULL VARCHAR2(10)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

SQL> desc SUBGROUPS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SGROUP                                    NOT NULL VARCHAR2(10)
 SG_DESC                                   NOT NULL VARCHAR2(150)
 PGROUP                                    NOT NULL VARCHAR2(10)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)

desc WHOD0S
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAME                                      NOT NULL VARCHAR2(50)
 SNAME                                              VARCHAR2(50)
 INSTITUTE                                          VARCHAR2(150)
 CREATE_DATE                               NOT NULL DATE
 CREATE_USER                               NOT NULL VARCHAR2(20)
 EMAIL                                              VARCHAR2(80)
 TEL                                                VARCHAR2(80)
 HMTEL                                              VARCHAR2(20)
 HOMEPAGE                                           VARCHAR2(150)
 GROUPS                                             VARCHAR2(400)
 UPDATE_DATE                                        DATE
 UPDATE_USER                                        VARCHAR2(20)
 STATUS                                             VARCHAR2(10)
 URL_PICTURE                                        VARCHAR2(150)
 FNALID                                             VARCHAR2(10)
 FNAL_EMAIL                                         VARCHAR2(50)



set pagesize 80;
set linesize 256;
column owner format a15;
column table_name format a20;
column column_name format a18;
column comments format a40;

select table_name from  all_tables where owner like '%SPEAKER%'
	order by TABLE_NAME;

TABLE_NAME
--------------------
CONFS
INSTITS
LINKS
MASTINSTS
PEOPLES
PGROUPS
SSGROUPS
SUBGROUPS
WHOD0S

9 rows selected.

select * from  all_col_comments where owner like '%SPEAKER%'
	order by TABLE_NAME;

 2  
OWNER           TABLE_NAME           COLUMN_NAME        COMMENTS
--------------- -------------------- ------------------ ----------------------------------------
SPEAKERDB       CONFS                URL                URL of the conference
SPEAKERDB       CONFS                ACONF              acronym name for the conference
SPEAKERDB       CONFS                NCONF              full name of the conference
SPEAKERDB       CONFS                LOCAT              Location
SPEAKERDB       CONFS                ST_DATE            Starting date of the conference
SPEAKERDB       CONFS                END_DATE           ending date
SPEAKERDB       CONFS                CREATE_DATE        Create date of record
SPEAKERDB       CONFS                CREATE_USER        Create date of record
SPEAKERDB       CONFS                LPROC              If there are proceedings
SPEAKERDB       CONFS                REG_DEAD           registration deadline
SPEAKERDB       CONFS                ABS_DEAD           Abstract submission deadline
SPEAKERDB       CONFS                SUB_DEAD           submission deadline
SPEAKERDB       CONFS                O_DEAD             Other deadline
SPEAKERDB       CONFS                O_DESC             Other description
SPEAKERDB       CONFS                UPDATE_DATE        Last Update Date
SPEAKERDB       CONFS                UPDATE_USER        Last Update Date
SPEAKERDB       INSTITS              INSTITUTE          Acronym Name of Institution
SPEAKERDB       INSTITS              AINST              acronym for masthead institution
SPEAKERDB       INSTITS              CREATE_DATE        Creation date
SPEAKERDB       INSTITS              CREATE_USER        Creator
SPEAKERDB       INSTITS              CONTACT            Contact Person
SPEAKERDB       INSTITS              PHONE              Contact Phone number
SPEAKERDB       INSTITS              FAX                Fax phone number
SPEAKERDB       INSTITS              VIDEOPHONE         Video conference phone number
SPEAKERDB       INSTITS              HOMEPAGE           Home page URL
SPEAKERDB       INSTITS              ADDR               Postal Address
SPEAKERDB       INSTITS              STATUS             Classification (a-authorlist,r-retired)
SPEAKERDB       INSTITS              UPDATE_DATE        Last Update Date
SPEAKERDB       INSTITS              UPDATE_USER        Last Updater
SPEAKERDB       LINKS                ID_LINK            Primary key integral identifier
SPEAKERDB       LINKS                ANAME              Acronym Name
SPEAKERDB       LINKS                ACONF              acronym name for the conference
SPEAKERDB       LINKS                CREATE_DATE        Create date of record
SPEAKERDB       LINKS                CREATE_USER        Creator
SPEAKERDB       LINKS                TOPIC              Nmae of the topic of the talk
SPEAKERDB       LINKS                TGROUP             Classification of the talk
SPEAKERDB       LINKS                PROC_URL           URL of the proceedings
SPEAKERDB       LINKS                TRANS_URL          URL of the topic
SPEAKERDB       LINKS                UPDATE_DATE        Last Update Date
SPEAKERDB       LINKS                UPDATE_USER        Last Updater
SPEAKERDB       MASTINSTS            UPDATE_USER        Last Updater
SPEAKERDB       MASTINSTS            AINST              acronym for masthead institution
SPEAKERDB       MASTINSTS            NINST              full masthead institution name
SPEAKERDB       MASTINSTS            STATUS             masthead institution status
SPEAKERDB       MASTINSTS            CREATE_DATE        Create date of record
SPEAKERDB       MASTINSTS            CREATE_USER        Creator of record
SPEAKERDB       MASTINSTS            UPDATE_DATE        Last Update Date
SPEAKERDB       PEOPLES              JOB_STATUS         Special Status
SPEAKERDB       PEOPLES              ANAME              Acronym Name
SPEAKERDB       PEOPLES              STATUS             On author list
SPEAKERDB       PEOPLES              AINST              acronym for masthead institution
SPEAKERDB       PEOPLES              CREATE_DATE        Create date of record
SPEAKERDB       PEOPLES              CREATE_USER        Creator
SPEAKERDB       PEOPLES              NAME               whod0 person name
SPEAKERDB       PEOPLES              LTALK
SPEAKERDB       PEOPLES              JOB_RANK           Job Rank
SPEAKERDB       PEOPLES              SERVICE_D0EXP      service tasks
SPEAKERDB       PEOPLES              SERVICE_GROUP      physics group service tasks
SPEAKERDB       PEOPLES              PREFERENCES        Preferred talk topic
SPEAKERDB       PEOPLES              EBOARDS            active in these editorial boards
SPEAKERDB       PEOPLES              OGROUPS            other activities
SPEAKERDB       PEOPLES              ST_DATE            Starting date at D0
SPEAKERDB       PEOPLES              UPDATE_DATE        Last Update Date
SPEAKERDB       PEOPLES              UPDATE_USER        Last Updater
SPEAKERDB       PGROUPS              PGROUP             group name
SPEAKERDB       PGROUPS              PG_DESC            group description
SPEAKERDB       PGROUPS              CREATE_DATE        Create date of record
SPEAKERDB       PGROUPS              CREATE_USER        Creator of record
SPEAKERDB       PGROUPS              UPDATE_DATE        Last Update Date
SPEAKERDB       PGROUPS              UPDATE_USER        Last Update User
SPEAKERDB       SSGROUPS             SSGROUP            SubSubGroup Name
SPEAKERDB       SSGROUPS             SSG_DESC           SubSubGroup Description
SPEAKERDB       SSGROUPS             SGROUP             SubGroup Name
SPEAKERDB       SSGROUPS             CREATE_DATE        Create date of record
SPEAKERDB       SSGROUPS             CREATE_USER        Creator of record
SPEAKERDB       SSGROUPS             UPDATE_DATE        Last Update Date
SPEAKERDB       SSGROUPS             UPDATE_USER        Last Updater of Record

OWNER           TABLE_NAME           COLUMN_NAME        COMMENTS
--------------- -------------------- ------------------ ----------------------------------------
SPEAKERDB       SUBGROUPS            SGROUP             SubGroup Name
SPEAKERDB       SUBGROUPS            SG_DESC            Subgroup description
SPEAKERDB       SUBGROUPS            PGROUP             group name
SPEAKERDB       SUBGROUPS            CREATE_DATE        Create date of record
SPEAKERDB       SUBGROUPS            CREATE_USER        Creator
SPEAKERDB       SUBGROUPS            UPDATE_DATE        Create date of record
SPEAKERDB       SUBGROUPS            UPDATE_USER        Last Updater
SPEAKERDB       WHOD0S               TEL                phone number
SPEAKERDB       WHOD0S               NAME               whod0 person name
SPEAKERDB       WHOD0S               SNAME              whod0 person name
SPEAKERDB       WHOD0S               INSTITUTE          Acronym Name of Institution
SPEAKERDB       WHOD0S               CREATE_DATE        Create date of record
SPEAKERDB       WHOD0S               CREATE_USER        Create date of record
SPEAKERDB       WHOD0S               EMAIL              email address
SPEAKERDB       WHOD0S               HMTEL              home phone number
SPEAKERDB       WHOD0S               HOMEPAGE           url of home page
SPEAKERDB       WHOD0S               GROUPS             D0 group associations
SPEAKERDB       WHOD0S               UPDATE_DATE        Last Update Date
SPEAKERDB       WHOD0S               UPDATE_USER        Last Update Date
SPEAKERDB       WHOD0S               STATUS             person's collaboration classification
SPEAKERDB       WHOD0S               URL_PICTURE        URL image of likeness
SPEAKERDB       WHOD0S               FNALID             Fermilab ID number
SPEAKERDB       WHOD0S               FNAL_EMAIL         Fermilab email address

100 rows selected.


select all_col_comments.table_name,
	all_col_comments.column_name,
	all_col_comments.COMMENTS
	from all_col_comments, all_tables

select * from  all_col_comments where owner like '%SPEAKER%'
	order by TABLE_NAME;
select table_name from  all_tables where owner like '%SPEAKER%'
	order by TABLE_NAME;

desc all_tables
