| Need Help in Oracle 10 g (merged) [message #413431] |
Wed, 15 July 2009 12:03  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
