Re: multirow inserts

I just have to say, I feel like Alice in Wonderland... Ok answer's are intermingled:

huh wrote:

> Cindy,
>
> Is it ensured that dual contains one and only row?

Yes.

>
> Could you tell me more about this table?

You will find this table documented in the SQL Language Reference Manual, (that's my server 7 copy) and probably in the same area of the Oracle 8 docs.

>
> - permissions (everyone has select access only
> or it is possible adding additional rows?)
> You select only from dual.

>
> What about the locking?
> None, you can select only from dual...

>
> BTW: Can I find description of all system
> tables - purpose, relations, column description, ...?
> Does ORACLE provide information similar
> to MS Back Office Knowledge Base (
> Bugs & fixies description, Informal articles ...)?

I am unfamiliar with MS Back Office Knowledge Base. Visit the Oracle site for that information. And even though I'm not a fan of this answer,
Read the Manuals.

Hope that helps,
Cindy

>
>
> TIA
>
> --
> Thank you for keeping >anti-spam< habit:
> not including my address in your reply.
Received on Tue Jun 29 1999 - 13:58:10 CDT