Home » SQL & PL/SQL » SQL & PL/SQL » Simple Select Statement (Oracle 9)
Simple Select Statement [message #359063] Thu, 13 November 2008 10:16 Go to next message
rabailey
Messages: 1
Registered: November 2008
Location: Danville, PA
Junior Member
I am new to PL language and Oracle. I've only had to deal with it on a limited basis. I am trying to do (in my opinion) a very simple and logical select stat
Re: Simple Select Statement [message #359065 is a reply to message #359063] Thu, 13 November 2008 10:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference

Regards
Michel
Re: Simple Select Statement [message #359066 is a reply to message #359063] Thu, 13 November 2008 10:35 Go to previous message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@rabailey,

I am not sure where you are facing problem. You can learn about PL/SQL using PL/SQL User's Guide and Reference

Quote:

The major nuance is that the form of the SELECT statement is different from its SQL form. After the SELECT clause, we must have an INTO clause listing variables, one for each attribute in the SELECT clause, into which the components of the retrieved record(NOTE: not records) must be placed.



Hope this helps.

Regards,
Jo
Previous Topic: error while executing function
Next Topic: Regular Expression Query (REGEXP_SUBSTR)
Goto Forum:
  


Current Time: Sun Dec 04 06:21:10 CST 2016

Total time taken to generate the page: 0.09020 seconds