[ILUG] [OT] Oracle for beginners ?

[Niall]

On Mon, 17 Jan 2000, John P. Looney wrote:

>  Anyone know of an Oracle site for beginners ? The equivalents of the
> following MySQL commands:

It's been a while since I Oracled so this is from memory and any or all of
it could be wrong.

>  show tables;

select * from tables;

Oracle represents everything as a table, and AFAIR tables is the table of
tables.

>  show users;
>  select * from user_auth;

Oracle uses an entirely different method of authorisation from MySQL.
Oracle uses grants, where you have a command like

grant this right for that table to that user

>  Something like phpMyAdmin, a PHP based MySQL admintool, that shows the
> SQL as it does simple graphical queries would rock too. Finally, some
> sample C code, that'll compile on a Linux box, that can talk to an Oracle
> database would rock also.

Haven't used C to talk to Oracle for years and never did with MySQL, but I
used Perl with Oracle and it worked just as with MySQL i.e. piece of cake,
thanks to the work of the DBI/DBD authors.

>  Is this a little complex for this list ? <grin>

Probably. OTOH the listas might think that having given Oracle pots of
money, you should have got some manuals, and having got them, perhaps
reading them would be good :-) (Yeah, I know, horrible thought)

Regards,

Niall  O Broin