Many modern databases support a more procedural approach to databases—they allow you to write procedural code to work with data. Usually, it takes the form of SQL interweaved with the more familiar IF statements, etc.
Note that this has nothing to do with accessing the database. You can access any database from virtually any language. What we’re talking about is the code that is executed by the database server.
While there are many various ‘database’ languages, we will only talk about the primary two: T-SQL, which is supported by SQL Server and Sybase, and PL/SQL, which is supported by Oracle.
Many other languages may be supported. For example, Oracle allows you to write stored procedures and triggers in Java, etc.
Note that this has nothing to do with accessing the database. You can access any database from virtually any language. What we’re talking about is the code that is executed by the database server.
While there are many various ‘database’ languages, we will only talk about the primary two: T-SQL, which is supported by SQL Server and Sybase, and PL/SQL, which is supported by Oracle.
Many other languages may be supported. For example, Oracle allows you to write stored procedures and triggers in Java, etc.
For you that want to know abaou Stored Procedure in PL/SQL, you can download e-book here !!!
1 comments:
Sepertinya pernah lihat isi e-booknya?
ngambil dari mana fan?
Post a Comment