$P!{PARAM} vs $P{PARAM}

[jaesun]

what's the difference between the usage?

 

I cannot find anything on this.  But I know there is a difference between the two, at least when I use the paramter in a SQL statement. 

[urtley]

The difference is $P! can hold an entire SQL statement.  For example:

select * from students where id = $P{student_id}

vs

select * from students $P!{student_id_condition}

we might define student_id_condition as "where id = 1"