oracle数据库
sql中变量模糊查询:
and (rpm.realpackage_desc like '%'||$P{realpackage_desc}||'%' or $P{realpackage_desc} is null)
sqlserver数据库
sql中变量模糊查询:
and (rpm.realpackage_desc like '%'+$P{realpackage_desc}+'%' or $P{realpackage_desc} is null)
oracle数据库
sql中变量模糊查询:
and (rpm.realpackage_desc like '%'||$P{realpackage_desc}||'%' or $P{realpackage_desc} is null)
sqlserver数据库
sql中变量模糊查询:
and (rpm.realpackage_desc like '%'+$P{realpackage_desc}+'%' or $P{realpackage_desc} is null)