I think that even if you do insert additional rows, you will only get one row when you select from it. Oracle does some special things with DUAL. It's not like a normal table.Mike
On Fri, Sep 19, 2008 at 7:46 AM, Darlei Soares <[EMAIL PROTECTED]>wrote: > > Rob Wolf is right, is so bad insert values in dual, i use the dual > table for calcs, exemple > > select (85/753)*5 from dual > > of for me to found the sysdate, is so bizarre insert values in dual > > 2008/9/19 Rob Wolfe <[EMAIL PROTECTED]>: > > > > You CAN, but what possible reason could you have that would possess you > to > > want to do such a bizarre thing? > > > > I am serious. This is just a VERY BAD IDEA and if anyone that worked for > > me was suggesting to me that they wanted to do it I would have to have a > > long think about their judgement. > > > > Rob > > > > On Fri, September 19, 2008 09:58, deepak sethi wrote: > >> Hi Karthi, > >> yes we can insert value into dual table > >> There is only one column dummy with varchar2 data type and length only > one > >> But we have to log in as sys (as SYSDBA) > >> > >> Regards > >> Deepak > >> > >> > >> > >> On Fri, Sep 19, 2008 at 6:28 AM, karthi keyan <[EMAIL PROTECTED]> > wrote: > >> > >>> Can we insert value into DUAL table? > >>> > >>> Regards, > >>> Karthi > >>> > >>> > > >>> > >> > >> > >> -- > >> Deepak Sethi > >> India > >> > >> > > >> > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
