这条语句中的project_id = :cProject_id and emp_id = :cEmp_id 里 =:表示什么意义?

Question

select a2.*
from (select *
      from analysys_emp_privs a
      where project_id = :cProject_id
        and emp_id = :cEmp_id
        and action_id = 'SELECT'
        and cat_id in (select /*+index(b) */object_value
                       from object_info b
                       where project_id = :cProject_id
                       start with object_id = '18023001'
                       connect by prior object_id = parent_object_id)) a1,
      Object_Info a2
where a1.project_id = a2.project_id
  and a1.object_id = a2.object_id

Answer 1

:cEmp_id 用的是绑定变量吧！

Answer 2

变量,前面加:号.不过这不是在oracle中直接使用的SQL.
是在比如PB代码里面的SQL.

Answer 3

project_id = :cProject_id and emp_id = :cEmp_id 写法应该不正确,
正确写法应该是project_id := cProject_id and emp_id := cEmp_id ,
:=cEmp_id表示把cEmp_id变量值赋给emp_id