This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:dbms_sql_mit_fetch_und_cursor [2011/12/06 14:01] mh |
kurs:dbms_sql_mit_fetch_und_cursor [2018/08/24 15:15] (current) admin |
||
---|---|---|---|
Line 48: | Line 48: | ||
on d.department_id = e.department_id where '||chr(10); | on d.department_id = e.department_id where '||chr(10); | ||
if p_first_name is not null then | if p_first_name is not null then | ||
+ | |||
+ | -- https://xkcd.com/327/ | ||
v_sql := v_sql || ' first_name = '''|| p_first_name | v_sql := v_sql || ' first_name = '''|| p_first_name | ||
||''' and '||chr(10); | ||''' and '||chr(10); |