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
github linkedin rss
  • 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
  • How I Structure My Flask Applications

    calendar Jun 27, 2013 · 1 min read
     en knowledgebase  · python
     ·
    Share on: twitter facebook linkedin copy
    How I Structure My Flask Applications

    How I Structure My Flask Applications Flask has been my preferred web framework as of late. I think it has a great core feature set and Armin, the main author, has done well to keep its API minimal and easy to digest even for developers that are relatively new to Python. However, given that it is a rather minimal framework, it can be often difficult to decide on how to structure an application after it reaches a certain level of complexity. It tends to be a common question that comes up in the #pocoo IRC channel.In this article I intend to share how I structure Flask applications. To help support this article Ive written a very basic application that Ive arbitrarily named Overholt. If you plan on following along I recommend having the source code open in your browser or a code editor.


    Read More
  • Con me o contro di me

    calendar Jun 26, 2013 · 3 min read
     it  · brelusca-world m5s opinion parlamento politic
     ·
    Share on: twitter facebook linkedin copy

    Quando frequentavo le medie inferiori nella mia classe si formarono due pseudo bande. I due presunti “capetti” non amavano molto la neutralità: “O sei con noi o sei contro di noi”. Per cui non mi fu possibile stabilire legami stabili con tali loschi figuri. Questa rigidità mentale era giustificata dalla giovane età oltre che dal fatto che si trattava di una scuola di periferia.


    Read More
  • Emacs Rectangles

    calendar Jun 8, 2013 · 1 min read
     en  · emacs
     ·
    Share on: twitter facebook linkedin copy

    Did you know? Emacs supports killing rectangles of text!


    Read More
  • Http1.0 on firefox

    calendar Jun 6, 2013 · 1 min read
     en  · http
     ·
    Share on: twitter facebook linkedin copy

    To force Firefox on http 1.0 proceed as follows:


    Read More
    • ««
    • «
    • 89
    • 90
    • 91
    • 92
    • 93
    • »
    • »»

Recent Posts

  • Netflix retro weird spirit
  • Yakuza Blues
  • FreeBSD on MacBook Mid 2009 with BroadCom WIFI
  • 6,76%

Categories

EN 485 IT 475 KNOWLEDGEBASE 186 SOFTWARE 178
All Categories
ADVERTISEMENT2 AUTOMATION5 BLOG-OBJECTSROOTCOM88 BOOKS3 COVID1919 DEVOPS28 EGGBOX4 EN485 ERLANG14 ESP82666 EVERGREEN4 FEATURED92 FLASH1 FREEDOM8 GENERATIVEAI3 HOMELAB1 HUMOR82 INTERVISTE2 IT475 JAVA3 JAVASCRIPT1 K8S-DONE-RIGHT3 KNOWLEDGEBASE186 LANG30 LETTERE-A-MIA-FIGLIA28 LETTERE-A-MIO-FIGLIO38 LIBRI3 NEWS3 ORG-MODE-PARSER9 PROJECTS8 PYTHON18 RACCONTI5 RECENSIONI17 RETRO-COMPUTING35 REVIEWS11 SITE12 SOFTWARE178 SOFTWARE-PROJECTS13 SQL27 UNCATEGORIZED1 UNIX-FEATURED7
[A~Z][0~9]

Series

ARDUINO 24 PROGRAMMING_LANGUAGES 7 RISPARMIO 5 FREEDOM 4
All Series
ARDUINO24 FREEDOM4 HOMELAB1 POLITICA3 PROGRAMMING_LANGUAGES7 RISPARMIO5
[A~Z][0~9]

Latest comments

    Giovanni Giorgi

    Copyright 1999-  GIOVANNI GIORGI. All Rights Reserved

    to-top