On Sep 19, 9:28 am, "karthi keyan" <[EMAIL PROTECTED]> wrote:
> Can we insert value into DUAL table?
>
> Regards,
> Karthi
Karthi,
If you connect as the user with SYSDBA privs, then you can,
but... just don't do it !
If you have any DML in your code, Pl/sql or any other application
using
DUAL table, you may have created whole bunch of new exceptions.
In many applications, there is an assumption that DUAL table will
always have only one row.
A code like SELECT ...INTO...FROM DUAL may start raising exception
TOO_MANY_ROWS
after your "experiment".
HTH
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
