Home » SQL & PL/SQL » SQL & PL/SQL » view
view [message #265254] Wed, 05 September 2007 22:44 Go to next message
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 #265257 is a reply to message #265254] Wed, 05 September 2007 22:46 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
I am unable to make my car go.
Please help.

If you expect any useful response try reading & following the STICKY post at top of this forum.
Re: view [message #265258 is a reply to message #265254] Wed, 05 September 2007 22:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ensure that view is properly created and you have select permission on that view.
Re: view [message #265260 is a reply to message #265258] Wed, 05 September 2007 22:53 Go to previous messageGo to next message
asra
Messages: 5
Registered: September 2007
Junior Member
how do i check i have permission to view
Re: view [message #265262 is a reply to message #265254] Wed, 05 September 2007 23:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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 .
Re: view [message #265502 is a reply to message #265262] Thu, 06 September 2007 08:03 Go to previous message
joy_division
Messages: 4642
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

Previous Topic: Problem regarding date function
Next Topic: table creation date
Goto Forum:
  


Current Time: Wed Dec 07 14:40:03 CST 2016

Total time taken to generate the page: 0.18317 seconds