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> |