On Sep 19, 3:19 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > On Sep 19, 12:30 pm, "Michael Moore" <[EMAIL PROTECTED]> wrote: > > > > > > > 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- Hide quoted text - > > > - Show quoted text - > > In 10g and later releases this is true, although this doesn't make > doing so a good idea. In 9i and earlier releases inserts into DUAL > are visible and can seriously affect database functionality. > > ********** DO NOT TRY THIS -- FOR ILLUSTRATIVE PURPOSES ONLY > ********** > > Database version 10.2.0.3.0 > > SQL> insert into dual values ('Z'); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select count(*) -- huh?!? what gives?!? > 2 from dual; > > COUNT(*) > ---------- > 1 > > SQL> select * from dual; -- now, that's weird... > > D > - > X > > SQL> delete from dual -- proves record exists, it just can't be seen > 2 where dummy = 'Z' > 3 / > > 1 row deleted. > > SQL> commit; > > Commit complete. > > SQL> delete from dual -- record no longer exists, try to delete it > anyway > 2 where dummy = 'Z' > 3 / > > 0 rows deleted. > > SQL> > > Oracle has, indeed, performed magic with DUAL in 10g and later > releases to keep fat fingers from ruining its functionality. > Unfortunately in 9iR2 and earlier versions such actions can seriously > affect applications and Oracle base functionality. > > David Fitzjarrell- Hide quoted text - > > - Show quoted text - Now this is even more bizarre: This is run from pl/sql Developer (Allround Automation)
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as SYS SQL> select * from dual; DUMMY ----- X SQL> insert into dual values ('Y'); 1 row inserted SQL> commit; Commit complete SQL> select count(*) from dual; COUNT(*) ---------- 1 SQL> select * from dual; -- NOTE 2 values. DUMMY ----- X Y SQL> select sysdate from dual; -- NOTE 1 value. SYSDATE ----------- 9/19/2008 5 SQL> delete from dual where dummy='Y'; 1 row deleted SQL> commit; Commit complete SQL> Magic.... 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 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 -~----------~----~----~----~------~----~------~--~---