Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    107

    Unanswered: What is the meaning of ":" in dynamic sql???

    friends,

    i saw a dynamic sql string in a procedure like below

    var := 'SELECT * FROM TEST WHERE A = :B';

    what that : before the B refers to????

    Jake

  2. #2
    Join Date
    Apr 2004
    Posts
    246
    The ":" indicates that whatever is following it is a bind variable, it's value to be provided later. As in:
    execute immediate var using 'testvalue';
    or
    execute immediate var using local_variable;

    The "B" has no meaning, as bind variables are positional, not named.
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Feb 2004
    Posts
    107
    thanks for the info...

    Jake

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •