kurs:bind_und_substitution_variablen
Differences
This shows you the differences between two versions of the page.
| — |
kurs:bind_und_substitution_variablen [2020/05/26 09:38] (current) admin created |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | /* | ||
| + | -- PL/SQL -- BIND Variablen | ||
| + | var b_max_salary number; | ||
| + | exec :b_max_salary := 8000; | ||
| + | select count(*) from employees where salary > :b_max_salary; | ||
| + | */ | ||
| + | |||
| + | -- Substitution Variablen | ||
| + | -- accept p_max_sal prompt "Max Salary eingeben: " default 10000; | ||
| + | def p_max_sal = 8000; | ||
| + | select count(*) from employees where salary > &p_max_sal; | ||
| + | </code> | ||
kurs/bind_und_substitution_variablen.txt ยท Last modified: 2020/05/26 09:38 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
