Oracle Query

• • Reply

  14 years ago

  by rajchekar

  rajchekar

  , India

  Joined 15 years ago

  Dear Developers,

  I'm having a Oracle Query Shown below

  select
  a.id id,
  a.name name,
  a.types types,
  b.mrstatetreet_id mrstatetreet_id
  from
  mrstatet a,
  mrstatetreemapt b
  where 
  a.types != '2'
  and
  a.ISUSE != 0
  and
  a.id = b.mrstatet_id
  and
  b.mrstatetreet_id = :mrstatetreet_id
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  In this Query what is the purpose of using : symbol.

  iF i RUN THAT IT GIVES THE ERROR 

   'Bind variable "MRSTATETREET_ID" not declared.'

   Can u clarify me.

  Thanks in advance

  Regards,

  RAJU

  Report abuse
• • Reply

  14 years ago

  by vmayur

  mayur

  , India

  Joined 14 years ago

  Hi Raju

    you are making  a simple but avoidable mistake

  "b.mrstatetreet_id = :mrstatetreet_id"

   

  this is wrong syntax

  use

  b.mrstatestreet_id = a.mrstatetreet_id

  ":mrstatetreet_id" is a bind variable which you are now done.

  follows my way you will get a right result

  
   
  

   

  Report abuse