Re: Newbie help

Check YOU'RE own grammar, please...

On Wed, 10 Jul 2002 00:15:52 GMT, "justme" <nobody_at_rogers.com> wrote:

>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 Thu Jul 11 2002 - 15:25:56 CEST