Oracle: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Geist (Diskussion | Beiträge) |
Geist (Diskussion | Beiträge) |
||
| Zeile 17: | Zeile 17: | ||
'''SQL ENGINE''' | '''SQL ENGINE''' | ||
SQL Statement Executor | SQL Statement Executor | ||
| + | 3 Schritte: | ||
| + | Parsing | ||
| + | Fetching | ||
| + | Executing | ||
| + | Bei der Ausführung optimiert der SQL-Optimierer | ||
Methoden wie "Bulk Insert" | Methoden wie "Bulk Insert" | ||
| − | + | Architecture | |
[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:01 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
SQL ENGINE SQL Statement Executor 3 Schritte: Parsing Fetching Executing Bei der Ausführung optimiert der SQL-Optimierer
Methoden wie "Bulk Insert"
Architecture
PL/SQL - Arrays