Re: Newbie help
Date: Wed, 10 Jul 2002 02:37:30 GMT
Message-ID: <K5NW8.467718$cQ3.39274_at_sccrnsc01>
"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?
>
The same as any procedure vs a function.
> 2. How do you obtain a result set from an Oracle Stored Procedure
>
RTFM
> 3. When is it appropriate to have a having caluse in a SQL statement?
>
When you need it.
> 4. Can you have both a where and having clause in one sql statement?
>
Yes
> 5. Why would you do this?
>
I want to apply a criteria after my where
> 6. How many times is the inner query of a corelated sub query executed
>
> 7. How do you create a temporary table in Oracle
>
Why would you. You can, but it is a rare thing to actually have to do this.
I look in the manual.
> 8. How would you obtain column names and definitions in oracle
>
Query the system catalogs
> 9. How can you tell the last time a table has been analysed
>
Query the system catalogs
> Thanks,
>
> Daniel
Your welcome.
If you send me $100 per question I will answer them more completely. Jim Received on Wed Jul 10 2002 - 04:37:30 CEST