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 -~----------~----~----~----~------~----~------~--~---
