1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

placeholder in dynamic SQL ?

Discussion in 'SQL PL/SQL' started by lubna, Mar 4, 2010.

  1. lubna

    lubna Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    HI
    I'm confuse to understand the concept of PLACEHOLDER in dynamic sql... I've also studied the link provided in this thread but still confused after reading how PLACEHOLDER are undeclared identifiers? Down there is the definition and their code. now someone tell me why we are using single quot starting at the delete KEYWORD and how we use colon for bind the variable?

     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    That is the Syntax of Dynamic SQL. Dynamic SQL Operation will be performed over an SQL string and it may contain Bind variable as place holder for the DML/DDL operations. And during the Execution of the Dynamic SQL these palceholders will be assigned with values .

    Dynamic SQL