sql - PHP + Oracle Soft Parsing Dynamically Sorted Queries -

i have php site oci connection oracle 11g database. bind variables in queries don't have hard parsing increases performance. lets want able sort output dynamically clicking button on page. understand can't bind variables order cause in oracle query, can build if statement in php , assign $orderby variable depending on order button clicked. understanding though each time when order clause changes, hard parse required , statements run slow. can this? please help!

this 1 of queries:

select * v_sopi_purchase_order contractor = :contractorname 

this can if pseudocode:

if (clicked search contractor) { $orderby = "order contractor"; } elseif (clicked search customer) { $orderby = "order customer"; } 

etc.

thank in advance! maksim