• sp_executesql : How to use ?

    By Francisco Antonio de Araujo e Souza on 7/10

  • delete duplicates in a table, with one SQL statement

    By Andy Archer on 5/12

  • delete duplicates in a table

    By Andy Archer on 5/12

  • delete duplicates in a table, using FOR UPDATE NOWAIT

    By Andy Archer on 5/12

  • UTL_FILE file utility - Unix write checker & Unix file remover

    By Andy Archer on 4/15

  • Click here to see a screenshot of this code!
    one-month calendar

    By Andy Archer on 4/5

    (Screen Shot)

  • Remove Character & Replace Character

    By Andy Archer on 3/30

  • Remove Bad ASCII

    By Andy Archer on 3/24

  • Oracle R12 - MOAC

    By Dinesh Kumar S on 3/8

  • Oracle Form Personalization

    By Dinesh Kumar S on 3/4

  • Oracle Forms

    By Dinesh Kumar S on 3/4

  • find all objects with <string> in their name

    By Andy Archer on 3/4

  • find all columns with <string> in their name

    By Andy Archer on 3/4

  • Click here to see a screenshot of this code!
    time in English

    By Andy Archer on 3/4

    (Screen Shot)

  • Click here to see a screenshot of this code!
    Sql Tiki with Triggers

    By Alejandro Botero Maya on 2/25

    (Screen Shot)

  • Oracle 11i - Procure 2 Pay

    By Dinesh Kumar S on 2/12

  • Oracle 11i - Multi Org

    By Dinesh Kumar S on 2/12

  • Click here to see a screenshot of this code!
    SQL*Plus "Pig" game

    By Andy Archer on 2/8

    (Screen Shot)

  • Click here to see a screenshot of this code!
    three-month "Past, Present, and Future" calendar

    By Andy Archer on 2/4

    (Screen Shot)

  • Click here to see a screenshot of this code!
    Employee Time of Arrival (ETA) prognosticator

    By Andy Archer on 1/26

    (Screen Shot)

  • Click here to see a screenshot of this code!
    virtual Magic 8-Ball

    By Andy Archer on 1/26

    (Screen Shot)

  • SQL*Plus "I'm thinking of a number between 1 and 10" game

    By Andy Archer on 1/21

  • six specialized Select statements

    By Andy Archer on 1/10

  • Age in years and months.

    By Dinesh Mishra on 1/2

  • SQL*Plus - back to the future with CMD ("DOS")

    By Andy Archer on 1/2