[techtalk] ? re Oracle/SQLPlus

[Becky L. Norum]

I'm trying to teach myself something about Oracle for school.  I've
started working with the book Oracle8 Programming: A Primer by
Sunderraman, which seems prety descriptive and good.  However, I'm having
a couple of problems/questions that I just cannot seem to find answers for
anywhere:

- how does one show the primary and foreign keys and the referential
constraints for tables?


- is there any very BASIC resource that you could recommend that would
serve as a primer for the structure/organization of Oracle on a UNIX
system?  Most of the guides out there seem to be for professional DBAs/ppl
who have prior database administration experience, which I do not have
(MSAccess is the extent of my database experience - I have to use it for
work.)

Thanks for your help,

Becky
bnorum at coe.neu.edu