download

Even the most focused Oracle professional can’t live at the SQL> prompt forever; every database career sometimes involves working outside the database. Learning a general-purpose programming language adds greatly to an Oracle professional’s effectiveness. The Python programming language is a very attractive option to meet this need. This article outlines Python’s advantages, demonstrates the essentials of writing Python, and supplies details on using Python against an Oracle database. Why Python? PL/SQL is a great programming language for use within the database, but all Oracle professionals run up against its limitations at some point. Manipulating files on disk, calling batchfiles or shell scripts, complex text parsing, heavily object-oriented work, and many other tasks can be difficult or even impossible in PL/SQL