| whether view or table? [message #200715] |
Wed, 01 November 2006 01:13  |
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
|
Senior Member |
|
|
hello orafaq team
i have created a table & a view. after a day when i want to know which one is view & which is table, i unable to recognise them.
ashish>select * from invasion;
CITY CONDIT TEMPERATURE LONGITUDE LATITUDE
--------------- ------ ----------- --------- --------
athens sunny 97 23 38
chicago rain 66 87 42
lima rain 45 77 12
manchester fog 66 45 43
paris cloudy 81 23 47
sparta cloudy 74 98 36
sydney snow 29 87 78
7 rows selected
this is a view (invasion) but i unable to differentiat them.
please provide me some help so that i could defferentiat it.
with regards
ashish
|
|
|
|
|
|
|
|
| Re: whether view or table? [message #200743 is a reply to message #200730] |
Wed, 01 November 2006 02:42  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Although Oracle does not enforce you to strictly use naming convention, it is good to have one. For example, prefix your tables with T_, views with V_, materialized views with MV_, packages with PKG_, etc. Doing so, you wouldn't be confused as you stated in your first post.
Internet is full of "naming convention" pages; here is one on Ask Tom, if you're interested in reading.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
