Questions from beginner-show tables, show databases??

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Sun, 30 Jul 2006 10:19 pm

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
Location: São Paulo

Poston Sun, 30 Jul 2006 10:22 pm

NOTE: a small note already have knowledge in SQL only focused on MySQL.
guinet
Location: São Paulo

Poston Mon, 31 Jul 2006 3:07 pm

Maybe you'vê been looking for this command ai: select * from all_tables
Marlon Pasquali
Location: Erechim - RS

Poston Tue, 01 Aug 2006 7:44 pm

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\";
guinet
Location: São Paulo

Poston Wed, 02 Aug 2006 8:15 am

select * from all_tables where owner = ' SYSTEM '
Marlon Pasquali
Location: Erechim - RS



Return to SQL

Who is online

Users browsing this forum: Google [Bot] and 4 guests