Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| plsql [2020/05/31 13:49] – andonovj | plsql [2021/07/14 10:42] (current) – [Projects] andonovj | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| =====Overview===== | =====Overview===== | ||
| - | PL\SQL takes a special place for me, because it was the first language which I had to learn all by myself. I found it very interesting and easy to grasp. No inheritance, | + | PL/SQL takes a special place for me, because it was the first language which I had to learn all by myself. I found it very interesting and easy to grasp. No inheritance, |
| I have created couple PL\SQL programs as you can see below: | I have created couple PL\SQL programs as you can see below: | ||
| =====Basics===== | =====Basics===== | ||
| - | - [[plsql_variables|Variables]] | ||
| - [[plsql_triggers|Triggers]] | - [[plsql_triggers|Triggers]] | ||
| + | - [[plsql_bind_varialbes|Parsing & Bind Variables]] | ||
| - [[plsql_static_dynamic_sql|Static & Dynamic SQL]] | - [[plsql_static_dynamic_sql|Static & Dynamic SQL]] | ||
| - [[plsql_autonomous|Autonomous Transactions]] | - [[plsql_autonomous|Autonomous Transactions]] | ||
| - [[plsql_debugging|Debugging]] | - [[plsql_debugging|Debugging]] | ||
| - [[plsql_sql_injection|SQL Injection]] | - [[plsql_sql_injection|SQL Injection]] | ||
| - | - [[plsql_security|Security rules]] | ||
| - | - [[plsql_packages_procedures_functions|Package a procedure]] | ||
| =====Projects===== | =====Projects===== | ||
| - [[plsql_fixer|Fixer Project]] | - [[plsql_fixer|Fixer Project]] | ||
| - [[plsql_etl_manipulation|ETL Manipulation for DB2]] | - [[plsql_etl_manipulation|ETL Manipulation for DB2]] | ||
| + | - [[plsql_insert_email_notifications|E-mail Notifications for Insert]] | ||
| + | - [[plsql_rest_api_call|Call RESTful API From Oracle]] | ||