Post by : admin
PL/SQL : Procedural Language/SQL is Oracle Corporation’s procedural language extension to SQL, the standard data access language for relational databases.
PL/SQL offers modern software engineering features such as data encapsulation, exception handling, information hiding, and object orientation, and so brings state-of-the-art programming to the oracle server and toolset.
8 PL/SQL is an extension to SQL with design features of programming languages.
8 Data manipulation and query statements of SQL are included within procedural units of code.
Benefit of PL/SQL
* Integration
PL\SQL plays a central role to both the Oracle Server (through stored procedures, stored functions, database triggers, and packages) and Oracle development tools (through Oracle Developer component triggers).
Oracle developer applications make use of shared libraries that hold code (procedures and functions) and can be accessed locally or remotely. Oracle developer consists of Oracle forms, Oracle Reports, and Oracle Graphics.
SQL datatypes can also be used in PL/SQL. Combined with the direct access that SQL provides, these shared datatypes integrate PL/SQL with the Oracle Server data dictionary. PL/SQL brides the gap between convenient access to database technology and the need for procedural programming capabilities.
* Improved performance
PL/SQL can be used to grop SQL statement together within a single block and to send the entire block to the server in a single call, thereby reducing networking traffic. Without PL/SQL, the SQL statements would be processed one at a time.
PL/SQL can also cooperate with Oracle Server application development tools such as Oracle Developer Forms and Reports. By adding procedural processing power to these tools, PL/SQL boosts performance.
* Portability
You can move programs to any host environment (operating system or platform) that supports the Oracle Server and PL/SQL.
* Modularity of program development
Berita
Telah dibuka untuk calon mahaswa baru tahun akademik 2020/2021, untuk program studi manajemen informatika dan Administrasi Bisnis, mulai Februari 2020, informasi lebih lanjut hubungi kampus…
indeks berita
Pengumuman
Kepada Mahasiwa aktif 2019/2020, yang telah mengikuti ujian akhir semester, untuk pendaftaran ujian perbaikan nilai, mendaftarkan diri hari senin, 27 Januari 2020. kepada bagian akademik
indeks pengumuman
Event
2025-00-00 :
indeks event
Pengecekan nilai atau posting komentar hanya bisa dilakukan oleh user yang sudah registrasi. Bagi mahasiswa yang belum registrasi harap menghubungi akademik.