Questions from beginner-show tables, show databases??

[guinet]

Hello friends I am starting to study Oracle 9i.

Including for having so much stuff on the internet ... I would ask friends indicate articles, tutorials on em portugues mainly in the area of General knowledge, SQLs in Oracle 9i. Would be very grateful.


Returning to doubt the topic ....
There is show tables, show databases??

Thanks for any help.

[/b]

[guinet]

NOTE: a small note already have knowledge in SQL only focused on MySQL.

[Marlon Pasquali]

Maybe you'vê been looking for this command ai: select * from all_tables

[guinet]

interesting was that even ... now I wanted to get all my database/table or schema?!?! \"system\" would that be?, no more wheel!: select TABLE_NAME from all_tables WHERE TABLE_SCHEM = \"system\";

[Marlon Pasquali]

select * from all_tables where owner = ' SYSTEM '