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 Esp8266 SQLite
Status
Links icon
GitHub LinkedIn
About
馃寪
English Italiano
github linkedin rss
  • oracle mass table drop

    calendar Jul 3, 2007 路 1 min read
     blog-objectsrootcom en  路 build easy oracle postgresql script small sql table ui vi
     路
    Share on: twitter facebook linkedin copy
    oracle mass table drop

    Sometimes I need to build a small script to delete a huge set of tables of a schema.


    Read More
  • Shopping in the IT

    calendar Jan 21, 2008 路 2 min read
     blog-objectsrootcom en software  路 ant apple arc database db engine file good google hard make microsoft mysql news opinion oracle ping search search-engine sql ui war web
     路
    Share on: twitter facebook linkedin copy
    Shopping in the IT


    Oracle buys BEA and Sun buys MySql.

    In reply,Migrosoft is hungry and is watching Yahoo :-)


    Read More
  • Windows x64: 32bit Odbc vs 64bit Odbc

    calendar Nov 10, 2011 路 1 min read
     en knowledgebase  路 database oracle
     路
    Share on: twitter facebook linkedin copy
    Windows x64: 32bit Odbc vs 64bit Odbc

    I run into a very big trouble on these days.


    Read More
  • Twitter il gradasso

    calendar Aug 25, 2012 路 2 min read
     it  路 api avvocato-del-diavolo development freedom mysql oracle
     路
    Share on: twitter facebook linkedin copy

    C’猫 una cosa fantastica di Internet: se qualsiasi societ脿 prova a fare la furba, inserendo delle righe scritte in piccolo quando revisiona la sua API da 1.0 a 1.1, state certi che ci sar脿 聽almeno una persona che si legger脿 tutto, trover脿 la fregatura e sputtaner脿 la summenzionata societ脿.

    E’ quello che 猫 successo con Twitter, e Marco Arment analizza nei dettagli le “novit脿” della nuova Twitter API che passa dalla versione 1.0 alla 1.1.

    Vi rimando all’articolo per i dettagli, ma in buona sostanza Twitter sta cercando di fare in modo che “se voi fate qualcosa di interessante con Twitter, bhe ora dovete collaborare con noi…per continuare a farlo….”:


    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鈥f 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
  • Debian perfect work environment

    calendar Sep 28, 2014 路 3 min read
     en featured software unix-featured  路 ibm linux oracle unix virtualization
     路
    Share on: twitter facebook linkedin copy
    Debian perfect work environment

    Working in a big company, my work laptop came with MS-Windows7 Enterprise installed. But as you imagine, Unix is my preferred desktop environment. So let’s how to configure a perfect Debian Linux for a old wolf consultant like me. You will be able to install commercial software mubmo jumbo like Oracle Express and IBM Websphere in a snap, and have a 64 rock solid system, easy to bring in a USB stick if you like.


    Read More
  • 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

    [caption id=“attachment_5294” align=“alignright” width=“150”]Disapprove with me! Disapprove with me![/caption]


    Read More
  • Oracle Database Sync

    calendar Nov 22, 2016 路 1 min read
     en featured knowledgebase sql  路 oracle tip
     路
    Share on: twitter facebook linkedin copy
    Oracle Database Sync

    Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.


    Read More
  • Oracle Auto increment trigger HOWTO

    calendar Dec 13, 2016 路 1 min read
     en featured knowledgebase sql  路 oracle tip
     路
    Share on: twitter facebook linkedin copy
    Oracle Auto increment trigger HOWTO

    Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.

    Even if聽 Oracle databases (<12) does not support auto increment, you can easily ask to your sql data modeler to generate for you a sequence and a trigger in a automatic way.


    Read More
  • Italian Accent Oracle fix

    calendar Feb 10, 2017 路 1 min read
     en sql  路 oracle relax
     路
    Share on: twitter facebook linkedin copy

    In Italian language we have accent words like 脿猫茅矛貌霉


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

Giovanni Giorgi

Master Solution Architect, father and free spirit.
Read More

Recent Posts

  • Interludio sul value investing
  • Anubis: DDos Protection
  • KarmaKit and Watchtower
  • FatLama for GenAI: The comeback!

Latest comments

    Disclaimer

    Gioorgi is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for website owners to earn advertising fees by advertising and linking to amazon.com, audible.com, and any other website that may be affiliated with Amazon Service LLC Associates Program. As an Amazon Associate we earn from qualifying purchases.
    Last updated:2025-05-27 02:00
    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top