Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done

to select all column from an Oracle view use asterisk:

SELECT * FROM APPIDVND0610.GET_LAST_TWO_CLOSE_BIDS

to select a single column from an Oracle view use double quotes:

SELECT "Latest_CloseBid" FROM APPIDVND0610.GET_LAST_TWO_CLOSE_BIDS

Posted on Monday, January 8, 2007 12:47 PM Oracle | Back to top


Comments on this post: select single column from Oracle view

# re: select single column from Oracle view
Requesting Gravatar...
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon
Left by bill on May 29, 2010 5:58 AM

# re: select single column from Oracle view
Requesting Gravatar...
I must admit that you hit the bull's eye! Very clever of you. Often I think about it and I agree with you on that. That's a good post.
Left by custom essay writer on Jun 08, 2010 6:00 AM

# re: select single column from Oracle view
Requesting Gravatar...
Wow!!!!! This is great... this will help me a lot in my development... two thumbs up... you're the best... please post more informative links like this
Left by ChuPiPing on Oct 17, 2010 7:12 AM

# re: select single column from Oracle view
Requesting Gravatar...
this is wrong. you need a semi-colon at the end of your statement. :D
Left by achuchu on Oct 17, 2010 7:14 AM

# re: select single column from Oracle view
Requesting Gravatar...
Hmmm did not see that... but still this is a nice info... Bill, you are an Oracle Guru... waiting for more topics to come
Left by ChuPiPing on Oct 17, 2010 7:17 AM

# re: select single column from Oracle view
Requesting Gravatar...
your kind of expertise is rare! i hope it stays that way :p
Left by admirer on Oct 17, 2010 7:26 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net