Treffer: Python for Oracle Geeks

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. Of course, most of us are too busy to invest large amounts of time in another language. For us, an ideal second language should be very easy to learn and use and should help us write highly readable, easily maintainable code, so that we can get value out of it without losing our focus on the database. On the other hand, it should be powerful and versatile, so that it will meet all our