SQL> create table T_BUSINESS_DATA(user_id number(16),status varchar2(2),oper_date date);
select * from T_BUSINESS_DATA t where 1=1 and t.APP_USER_ID=:userId and t.STATUS <> 1 order by t.operDate desc
SQL> variable userId number;
SQL> exec :userId := 1;
PL/SQL procedure successfully completed.
select *
from T_BUSINESS_DATA t
where 1 = 1
and t.user_id = :userId
and t.STATUS <> 1
order by t.oper_date desc
SQL> select distinct user_id from T_BUSINESS_DATA;
USER_ID
----------
1
2222
999
3
10
select *
from T_BUSINESS_DATA t
where 1 = 1
and t.user_id = :userId
and t.STATUS <> 2
order by t.oper_date desc;
select *
from T_BUSINESS_DATA t
w
sql 绑定变量问题
最新推荐文章于 2024-07-11 03:26:57 发布
本文深入探讨了SQL中绑定变量的概念,解释了为何使用绑定变量可以提高查询效率并减少SQL注入风险。通过实例展示了如何在不同数据库系统中实现绑定变量,并分析了可能出现的问题及解决方案。
摘要由CSDN通过智能技术生成