| view [message #265254] |
Wed, 05 September 2007 22:44  |
asra
Messages: 5
Registered: September 2007
|
Junior Member |
|
|
|
I am unable to retrive records when query in view. i am able to retrive records if i query in table. i have set DBMS clint info still unable to.... Please help
|
|
|
|
|
|
|
|
|
|
|
|
| Re: view [message #265502 is a reply to message #265262] |
Thu, 06 September 2007 08:03  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| Arju wrote on Thu, 06 September 2007 00:01 | select * from view_name
If it executes without error then you have select permission on the view.
If error comes then you don't have.
Be more precise. You have not specified in your question about error number .
|
Partial answer. There are many many reasons.
1. no view exists
2. misspelled
3. in a different schema
4. no rows exist because of the join
etc.
[Updated on: Thu, 06 September 2007 08:05] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
