[ILUG] [OT] Oracle for beginners ?

[Stephen_Reilly at dell.com]

"John P. Looney" wrote:
> 
>  Anyone know of an Oracle site for beginners ? The equivalents of the
> following MySQL commands:
> 
>  use database;

>>er...
this would be part of your login script, once you point to one server you
can only point to one database. After that what you see are schemas, what
the DBA has allowed you to see. The database is not named, its just Oracle
and there can be only one. 

>  show tables;

>>just got this today:
>>select table_name from user_tables;
select table_name from all_tables -- every table you can see
select * from tab -- all tables you own

>  show users;

>>er...
easiest way is to use Oracle navigater on server side and look through users

>  select * from user_auth;

er...
select * from user_privilages_tab
select * from table_privilages_tab

>  describe <tablename>;

desc <tablename>;
--correct

--steve

kevin
-- 
kevin at suberic.net                              Nutrition Facts
fork()'ed on 37058400		       Puns: 100% RDA  (% good puns: 0)

-- 
Irish Linux Users' Group: ilug at linux.ie
http://www.linux.ie/mailman/listinfo/ilug for (un)subscription information.
List maintainer: listmaster at linux.ie