Oracle syntax >= :1 means

Question

Can someone tell me what oracle syntax >= :1 means? Example

Select * from someTable s WHERE (TRUNC(s.ShippedOn)) >= :1

in this example ShippedOn is a NUMBER(20,10)

thanks Niall

Answer 1

Your Select statement is dynamic sql statement and (TRUNC(s.ShippedOn)) >= :1 is means (TRUNC(s.ShippedOn)) is greater than or equal to bind variable value which you will pass at run time. More info in this page .

Answer 2

It means greater than or equal to a bound varable