User Tools

Site Tools


kurs:bind_und_substitution_variablen

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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