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