open-menu closeme
Home
RetroComp icon
Retro Computing Articles Composition Notebooks 8bit
DevOps icon
Automation K8s Done Right
GenAI icon
Fatlama Newsletter Generative AI
Projects icon
Software Projects Arduino Misterio Esp8266 SQLite
Status
Links icon
GitHub LinkedIn
About
github linkedin rss
  • ORA-01461: can bind a LONG value only for insert into a LONG column

    calendar Sep 1, 2015 · 1 min read
     en knowledgebase  · bad oracle relax sql
     ·
    Share on: twitter facebook linkedin copy
    ORA-01461: can bind a LONG value only for insert into a LONG column

    Disapprove with me! Disapprove with me!

    Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock.


    Read More
  • Oracle Invalid number ORA-01722

    calendar Jul 15, 2013 · 1 min read
     en knowledgebase sql  · bad bug oracle sql
     ·
    Share on: twitter facebook linkedin copy
    Oracle Invalid number ORA-01722

    I stumbled upon a very brain-f**k error on Oracle 10g on these days.

    Context: the following query [sql]SELECT * FROM (
    SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE
    AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers.

    Why?

    Well…if you ask to “explain plan”, you will get something like

    • a table full scan
      • Filter Predicates AND
        • I_LIKE=UPPER('STATIC_CONDITION')
        • TO_NUMBER(S.SNDG) >2000
        • CUSTOMER_ID NOT LIKE '%P%'

    Read More
  • Linkedin privacy simpatia

    calendar Jan 31, 2012 · 1 min read
     humor it  · bad ideas privacy
     ·
    Share on: twitter facebook linkedin copy

    Dovete stare molto attenti alla vostra Privacy. Mi hanno fato notare che LinkedIn ha silenziosamente attivato un checkbox che consente di usare la vostra foto per…farsi pubblicità!


    Read More
  • Lega per l’abolizione di Maven

    calendar Sep 8, 2011 · 1 min read
     humor it  · bad ideas
     ·
    Share on: twitter facebook linkedin copy

    Da Wikipedia leggiamo

    A maven (also mavin) is a trusted expert in a particular field, who seeks to pass knowledge on to others. The word maven comes from the Hebrew, viaYiddish, and means one who understands, based on an accumulation of knowledge

     

    Ora il professor Pippero ha stilato la seguente top ten delle frusrazioni


    Read More
  • Automatically refresh your user’s Session behind the scenes using jQuery and Asp.Net

    calendar Mar 10, 2011 · 1 min read
     en software  · bad ideas jquery tip
     ·
    Share on: twitter facebook linkedin copy
    Automatically refresh your user's Session behind the scenes using jQuery and Asp.Net

    Sometimes, a client-based refresh of the session is the only viable option.


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • »
    • »»

Recent Posts

  • Misterio Is Back
  • Netflix retro weird spirit
  • Yakuza Blues
  • FreeBSD on MacBook Mid 2009 with BroadCom WIFI

Latest comments

    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top