Re: Newbie help

do you own homework please...
"David Brien" <dbrien_at_nycboe.net> wrote in message news:603fdc51.0207090757.25f3d773_at_posting.google.com...
> I'm a SQL Server guy trying to learn Oracle. I've used it for a long
> time but never really developed with it. Can anyone answer these
> simple questions?
>
> 1. What is the difference between an Oracle Stored Procedure and
> Function?
>
> 2. How do you obtain a result set from an Oracle Stored Procedure
>
> 3. When is it appropriate to have a having caluse in a SQL statement?
>
> 4. Can you have both a where and having clause in one sql statement?
>
> 5. Why would you do this?
>
> 6. How many times is the inner query of a corelated sub query executed
>
> 7. How do you create a temporary table in Oracle
>
> 8. How would you obtain column names and definitions in oracle
>
> 9. How can you tell the last time a table has been analysed
>
> Thanks,
>
> Daniel
Received on Wed Jul 10 2002 - 02:15:52 CEST