Re: newbie questions..

eugene kim <eugene1977_at_hotmail.com> wrote in message news:<akspfp$ft0$1_at_newsreader.mailgate.org>...
> hi
> in postgresql
>
> i would
> createdb mydb --> create database named mydb
> psql mydb --> connect to mydb
> create table mytable blah blah;
> \d --> shows what table i have in this db
>
>
> i can't find how to do any of these three in oracle 9i..
> --;
> thx in advance
> and is there a good concise tutorial or book for a novice
> such as 'practical postgresql' for postgresql
>
> thanks

You will need to pull the Concepts manual. It pretty well explains the basic concepts of how to build and maintain an instance and the database under it in the first couple of chapters.

See the SQL Manual: create database for the sql statement to create an oracle database

To find out information about objects in the database see the rdbms dictionary, which is documented in the Oracle 9i Reference Manual. But basically for every database object: table, index, constraint etc... there is a set of dictionary tables, all_, dba_, and user_ so you can try:

select * from user_tables
select * from user_indexes
select * from user_views
select * from user_constraints

Visit the cooperative FAQ at
http://www.jlcomp.demon.co.uk/faq/ind_faq.html and you will find several articles on Dictionary tables plus a lot of other topics of interest if your are going to be doing series work with Oracle.

• Mark D Powell --