Acrobat X Files

Home > Programming > Oracle Programming

Python for Oracle Geeks

Sort Desciption:

This article outlines Pythons 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 ...

Content Inside:

Python for Oracle Geeks Even the most focused Oracle professional cant 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 professionals effectiveness.  The Python programming language is a very attractive option to meet this need. This article outlines Pythons 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 needs and wont force us to go looking for yet more languages to cover its gaps. Finally, it would be nice if it were free, to spare us the hassle of getting permission for a new purchase. Python meets all these requirements. It is an open-source, object-oriented,  high-level, general- purpose interpreted language available without cost on all common computing platforms. Its elegant, straightforward syntax helps programmers write clean, readable code. Rather than try to introduce Python thoroughly or teach it rigorously, this article will jump right into demonstrating its use in some Oracle-related tasks.  If it convinces you that Python is worth checking out further, the links listed ...

Source: www.ioug.org

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...