• (cs) in reply to Nate Dogg
    Anonymous:
    Anonymous:

    I hate Oracle and everything it stands for.  If you like Oracle, then I'm sorry, but you have an illness.  If you are forced to use Oracle because your management doesn't know better, then I'm also sorry. 

    tdog



    I am curious what you feel is a valid alternative ;) Though I tend to agree, I might guess that your DB of choice might also be a steaming pile of crap (unless you are talking about Postgres, then, never mind.).  But, if you are talking about SQL server,  gadzooks! SQL server is teh WORST db there is (yes Alex, worse than MySQL).

    This comment applies to both of you...

    Based on what?  What evidence or proof do you have, and based upon what features, arguments, etc?  All RDBMS' have their pros and cons.  Your argument is similar to saying that any Pontiac is the spawn of the devil, based upon the fact that some Fieros had a minor problem of catching fire...

    Frankly, if I've got a mission-critical project and I need five 9's on reliability, Oracle is probably about the only thing I'd consider.  Conversely, if I'm writing a basic package, Oracle is massive overkill.

  • (cs) in reply to GalacticCowboy
    GalacticCowboy:
    Anonymous:
    Anonymous:

    I hate Oracle and everything it stands for.  If you like Oracle, then I'm sorry, but you have an illness.  If you are forced to use Oracle because your management doesn't know better, then I'm also sorry. 

    tdog



    I am curious what you feel is a valid alternative ;) Though I tend to agree, I might guess that your DB of choice might also be a steaming pile of crap (unless you are talking about Postgres, then, never mind.).  But, if you are talking about SQL server,  gadzooks! SQL server is teh WORST db there is (yes Alex, worse than MySQL).

    This comment applies to both of you...

    Based on what?  What evidence or proof do you have, and based upon what features, arguments, etc?  All RDBMS' have their pros and cons.  Your argument is similar to saying that any Pontiac is the spawn of the devil, based upon the fact that some Fieros had a minor problem of catching fire...

    Frankly, if I've got a mission-critical project and I need five 9's on reliability, Oracle is probably about the only thing I'd consider.  Conversely, if I'm writing a basic package, Oracle is massive overkill.

     

    GalacticCowboy nailed it. Any software that has stood the test of time has its place, even Weblogic [^o)] Oracle is unchallenged in its main niche, so they must be doing something right.

    Could the first guy have been talking about Oracle Corporation, not Oracle the DBMS? I don't much like Java's wacky inheritance rules, but I don't say "I hate Sun and everything it stands for"

  • FascistBaby (unregistered) in reply to makomk

    Enric Naval and Makonk -

    It looks like SecretGeek saw your errors and has fixed both W2SCG and W3SCG. In fact the example text in W3SCG inludes both "fightin'" and "cussin'". Yeehaw, good work all!!

    FB

  • Niall Litchfield (unregistered) in reply to mrsticks1982
    mrsticks1982:

    even their light footprint is still 2gb!!! "Oracle is the Devil"

    2gb=150mb ah well.

     

     

     

  • (cs) in reply to FascistBaby
    Anonymous:
    Enric Naval and Makonk -

    It looks like SecretGeek saw your errors and has fixed both W2SCG and W3SCG. In fact the example text in W3SCG inludes both "fightin'" and "cussin'". Yeehaw, good work all!!

    FB

    Well... I used "cussin´" because it was on the example text. A very nice WTF: the code chokes on some of the example tokens the programmer himself is providing!

    And I dind't warn the programmer myself because a)the add comment link is broken b)there are several posts for the second generator, but none for the third one. Way to go, SecretGeek! Solve the problems on your website! I have finally found his email address in the about link, so I'll email him about this.

  • (cs) in reply to Enric Naval

    thanks Enric, Makonk, FB et al.

    I've seen the error but haven't fixed it yet. the 'world's third simplest code generator' isn't actually released yet, the url has just been leaked a few times

    When it is released this problem will be fixed, and i'll remove the google ads as well.

    Man do i feel dumb, having to log in to daily-wtf to explain my bugs....:$

    cheers lb

    http://secretGeek.net

  • (cs)

    Oracle database - great.

    Oracle development tools and utilities absolutely terrible - buggy, unintuitive and do strange things like this.

     

  • earl507 (unregistered) in reply to Paul

    Here is the actual template used.....

    begin
    if '#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')>0 then
      execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#, #3#))';
    elsif '#1#' = 'INTEGER' or
      ('#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')=0) or
      '#1#' = 'VARCHAR2' then
      execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#))';
    else
      execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#)';
    end if;
    end;


    <!--[CDATA[begin<br>if '#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')>0 then<br>  execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#, #3#))';<br>elsif '#1#' = 'INTEGER' or <br>  ('#1#' = 'NUMBER' and length('#1#')>0 and length('#2#')=0) or<br>  '#1#' = 'VARCHAR2' then<br>  execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#(#2#))';<br>else<br>  execute immediate 'alter table "#OBJECT_OWNER#"."#OBJECT_NAME#" add(#0# #1#)';<br>end if;<br>end;]]-->

  • scarletmanuka (unregistered) in reply to earl507

    And, as has been pointed out, this is badly broken. Obviously every instance of <FONT face="Courier New" size=2>'#1#' = 'NUMBER' and length('#1#')>0</FONT> is ridiculous, and as several people have mentioned every clause containing <FONT face="Courier New" size=2>and length('#2#')=0</FONT> is broken too.

    What I don't think has been much mentioned is that the length checks appear to be on the wrong inputs: change every occurrence of <FONT face="Courier New" size=2>length('#2#')</FONT>to <FONT face="Courier New" size=2>length('#3#')</FONT>, and change <FONT face="Courier New" size=2>length('#1#')</FONT>to <FONT face="Courier New" size=2>length('#2#')</FONT>, and it makes much more sense: if precision and scale are both specified and the datatype is NUMBER, issue a statement with precision and scale; if the type is INTEGER or VARCHAR2 or NUMBER with precision but no scale, issue a statement with precision specified; otherwise issue a statement without precision or scale.

    Now that would make sense, and then it would only be the length(x)=0 stuff that would be broken. (Though I admit it's rather sad to have to say about a very short piece of code that if only a major problem had been fixed, it would only be broken in one way.) But for a template to be checking obviously the wrong inputs in released code is pretty WTF-worthy.

  • Gunner (unregistered) in reply to diaphanein
    Anonymous:

    Anyone care to explain the difference between the following 3 items?

    add(FIREDATE DATE(, ))

    add(FIREDATE DATE())

    add(FIREDATE DATE)

    Is there a difference?

    Therein likes the WTF...

  • Bart (unregistered) in reply to Rain Dog

    Bugfree. Yeah right.

     

    I remember well a (quite nasty) view we made which gave unpredictable results. We contacted support and (and I have to say: that is real competence) within one or two days it was patched.

    There is a certaintity of 100% that Oracle is NOT bugfree (I think they do a good job though)

    I don't know about the security vulnerabilities - but in 99% of the cases possible vulnerabilities are caused by incompetent / clumpsy dba and operators.

     

  • v. (unregistered)

    Well, at least it wont generate a type such as "Orable"

  • Thomas (unregistered) in reply to earl507

    I tried the same on a MySQL database with phpMyAdmin and it came up with this code:

    ALTER TABLE `emp` ADD `firedate` DATE NULL

    Captcha: sagaciter (wouldn't that be a fun job?)

  • Kancelaria Upadłość Konsumencka (unregistered)
    Comment held for moderation.
  • jak pozycjonować stronę wordpress (unregistered)
    Comment held for moderation.
  • jak pozycjonować stronę wordpress (unregistered)

    http://envico.co.kr/bbs/board.php?bo_table=s4_3&wr_id=43215 Very good article! We are linking to this particularly great content on our site. Keep up the great writing. http://wood-max.co.kr/bbs/board.php?bo_table=free&wr_id=90680 http://www.summerband.co.kr/bbs/board.php?bo_table=qa&wr_id=75109

  • Lara (unregistered)
    Comment held for moderation.
  • Pilar (unregistered)

    This Week's Most Remarkable Stories About Accident Injury Claim Compensation best auto accident attorney (http://shypo.gsdt.kr/)

  • Mora (unregistered)
    Comment held for moderation.
  • Jefferey (unregistered)
    Comment held for moderation.

Leave a comment on “Orable Generated Code”

Log In or post as a guest

Replying to comment #:

« Return to Article