dokuwiki

/*
-- 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;