On Thu, 4 Sep 2008 18:02:19 +0200, "Philip Newton" <[email protected]> wrote:
> On Thu, Sep 4, 2008 at 17:51, Matthew King <[email protected]> wrote: > > Perl can implicitly munge strings & numbers, that's what makes it > > simultaneously hateful and not. Databases should do what they're told. > > Does that include implicitly converting an empty string into NULL? That's Oracle. A multitude of more hate than MySQL. WTF does Oracle 10g come with a "Recycle Bin" I want a database, not a fucking windows OS! More hateful is that the Recycled tables are just as visible as the rest, so when you want to select the count from all tables, you just go through all tables and 'select count (*) from $table', and see your program crash when you hit a recycled table with a message that you cannot select from recycled tables. THEN DON'T FUCKING SHOW THEM UNLESS I EXPLICITLY TELL YOU TO LOOK IN YOUR TRASH CAN ASS HOLE! Meanwhile I found the solution: SQL> ALTER DATABASE FLASHBACK OFF; and add "recyclebin = OFF" to the .ora startup file It is sad it only solves one problem > Hateful, the lot of them. Including the "enterprisey" ones. Perhaps > especially those. -- H.Merijn Brand Amsterdam Perl Mongers http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00, 11.11, 11.23, and 11.31, SuSE 10.1, 10.2, and 10.3, AIX 5.2, and Cygwin. http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
