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
> 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)
Niall O Broin
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!