Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question

Re: Newbie question

From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 06 Jan 2003 21:43:11 +0100
Message-ID: <3E19EA5F.9060102@netscape.net>


George wrote:
> I am coming from a SQL Server background so be gentle...
>
> I am trying to get this simple procedure worked out and it compiles invalid.
> What am I doing wrong
>
> BEGIN
> SELECT SSN FROM STUDENT;
> END;
>
>

Reading all of the thread thus far:
- Daniel, I can speak for myself - no need for your frank to

   speak as well ;-)
- all you probably needed was:

select ssn from student;

that's client code, and will return all ssn's found in the student table. If you want just one (possibly a few), introduce a where-clause:

select ssn from student
where first_name = 'FRANK';

Frank Received on Mon Jan 06 2003 - 14:43:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US