Re: sort-of-simple Oracle questions

> 1. Can a field in a table be a list of items (i.e., field EMAIL of
> table CUSTOMER contains a list of all email addresses the customer
> has)? Or, must you use a different table to encompass this info in the
> design?

You could create the columns as an object or nested table or something, but you don't want to for this purpose. You could concatenate the address together with a comma separator in-between and let your application parse them (even create a PL/SQL function to do it) but I wouldn't. Create a separate email address table with CUSTOMER_ID and SEQ_NUM as the primary key.

> 2. Is there a SQL command to simply view the current tables that exist
> in a tablespace - just their names... or a tool that can do it
> (sqlplus, svrmgrl, ect)

SELECT table_name form DBA_TABLES, but you need to have the DBA role to do this.
SELECT table_name from ALL_TABLES will get you the same thing (minus system tables and stuff).
SELECT table_name from USER_TABLES get all tables owned by the current schema you're logged on to.

> 3. What useful log files are there? I know about listener.log which
> logs connection attemts to the Oracle listener, but what about logs for
> interaction with the database itself (i.e., record failed SQL attempts,
> ect...)

Better advice than answering this is to advise you to purchase TOAD (Tool for Oracle Application Developers). If you are an application developer, a DBA (and especially if you're the jack-of-all-trades kind of guy) you have to have this tool and none other. Platinum can't rival it (Computer Associates now) and ORACLE 'definately' can't rival it. It's way too inexpensive not to have.

Steve Parker <steve_at_naweb.com> wrote in message news:3829BB4C.9AAAF2A8_at_naweb.com...
> hello all,
>
> I running Oracle 8.0.5 on Linux...
>
> I have a few questions i hope somebody could help me with:
>
> 1. Can a field in a table be a list of items (i.e., field EMAIL of
> table CUSTOMER contains a list of all email addresses the customer
> has)? Or, must you use a different table to encompas this info in the
> design?
>
>
>
> 2. Is there a SQL command to simply view the current tables that exist
> in a tablespace - just thier names... or a tool that can do it
> (sqlplus, svrmgrl, ect)
>
>
>
> 3. What useful log files are there? I know about listener.log which
> logs connection attemts to the Oracle listener, but what about logs for
> interaction with the database itself (i.e., record failed SQL attempts,
> ect...)
>
>
>
> Any help with these oddly dispersed questions would be greatly
> appreciated.
>
> thanks,
> steve
>
Received on Wed Nov 10 1999 - 14:31:32 CST