Home » Other » General » Need Help in Oracle 10 g (merged)
Need Help in Oracle 10 g (merged) [message #413431] Wed, 15 July 2009 12:03 Go to next message
aabhishekc
Messages: 1
Registered: July 2009
Location: Mumbai
Junior Member
Hi Member,

I am new user of oracle 10 g. I have many issues in this :
1. I am have created many table in this version but when i am going to see all table to use this query
desc tab
i am getting this output not all table which are created and other sample table.

Output

Name Null? Type
---------------------------------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER


Please anyone can tell me

1.how can i see all table.
2.how can use my created schema and other example tables.
3.Query to see all schema which are exist in database.

Thanks in advance
Abhishek.
Re: Need Help in Oracle 10 g (merged) [message #413437 is a reply to message #413431] Wed, 15 July 2009 12:34 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DICT is a view that contains all dictionary views.

Dictionary views are described in Database Reference

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: Installation Guid of Oracle 10g (9.0.4)
Next Topic: What sort of Questions would you ask in Interview..
Goto Forum:
  


Current Time: Thu Mar 28 06:41:08 CDT 2024