Can someone give me an example of a bind variable and when it should be used ?

What is parallel query and how do you make a query a parallel ?

thanks