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