Oracle: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Geist (Diskussion | Beiträge) |
Geist (Diskussion | Beiträge) |
||
| Zeile 14: | Zeile 14: | ||
'''PL/SQL ENGINE''' | '''PL/SQL ENGINE''' | ||
Procedural Statment Executor | Procedural Statment Executor | ||
| + | |||
| + | Architecture | ||
| + | - Cooperates with SQL Engine | ||
| + | - Enables Subprograms | ||
| + | - Dynamic Queries | ||
| + | - Case Insensitivity | ||
| + | - Oracle Style | ||
| + | - Optimizer | ||
| + | - Enables Object-Orinted Programming(OO Programmierung mit abstrakten Datentypen) | ||
| + | |||
'''SQL ENGINE''' | '''SQL ENGINE''' | ||
| Zeile 25: | Zeile 35: | ||
Methoden wie "Bulk Insert" | Methoden wie "Bulk Insert" | ||
| − | + | [https://docs.oracle.com/database/121/TDDDG/tdddg_dml.htm#TDDDG99941 About DML Statements and Transactions] | |
| − | [https://docs.oracle.com/database/121/TDDDG/tdddg_dml.htm#TDDDG99941 About DML Statements and Transactions] | ||
| − | |||
[https://www.tutorialspoint.com/plsql/plsql_arrays.htm# PL/SQL - Arrays] | [https://www.tutorialspoint.com/plsql/plsql_arrays.htm# PL/SQL - Arrays] | ||
Version vom 3. Juni 2022, 11:15 Uhr
PL/SQL
PL/SQL stands for “Procedural Language extensions to the Structured Query Language”. SQL is a popular language for both querying and updating data in the relational database management systems (RDBMS). PL/SQL adds many procedural constructs to SQL language to overcome some limitations of SQL. Besides, PL/SQL provides a more comprehensive programming language solution for building mission-critical applications on Oracle Databases.
PL/SQL is an embedded language. PL/SQL only can execute in an Oracle Database. Platform Independence
- Oracle Forms
PL/SQL ENGINE Procedural Statment Executor
Architecture - Cooperates with SQL Engine - Enables Subprograms - Dynamic Queries - Case Insensitivity - Oracle Style - Optimizer - Enables Object-Orinted Programming(OO Programmierung mit abstrakten Datentypen)
SQL ENGINE SQL Statement Executor 3 Schritte: Parsing Fetching Executing Bei der Ausführung optimiert der SQL-Optimierer
Methoden wie "Bulk Insert"
About DML Statements and Transactions
PL/SQL - Arrays