Herşey ilk adımlarla başlar...

Monday, January 31, 2011

Dynamic SQL

1/31/2011 Posted by Nurettin Onur YAKIT , , , , , , No comments
Dynamic SQL used to run SQL's during runtime.. You are able to create the sql sentence inside a function an run it. Like this ;

 EXECUTE IMMEDIATE    'SELECT '
                           || seq_name
                           || '.NEXTVAL FROM dual'

seq_name is a variable that is passed inside our function.

0 comments: