This shows you the differences between two versions of the page.
kurs:bind_variablen_im_sql [2014/09/10 21:22] |
kurs:bind_variablen_im_sql [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | SQL> var bla varchar2(30); | ||
+ | SQL> exec :bla := 'huhuh'; | ||
+ | PL/SQL procedure successfully completed. | ||
+ | |||
+ | SQL> print :bla; | ||
+ | |||
+ | BLA | ||
+ | -------------------------------- | ||
+ | huhuh | ||
+ | |||
+ | SQL> exec select 'blu' into :bla from dual; | ||
+ | |||
+ | PL/SQL procedure successfully completed. | ||
+ | |||
+ | SQL> print :bla; | ||
+ | |||
+ | BLA | ||
+ | -------------------------------- | ||
+ | blu | ||
+ | </code> |