Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question
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
![]() |
![]() |