Oracle Escape Characters

[Nerdfest]

I'm looking for a way to change the escape characters used to define wildcards, etc within "Like" statements. Oracle doesn't seem to have a way to define wildcards at a session level and I can't see a way to do this one a per-statement level (it requires something like Select * from X where Y like "\%something" escape "\"). Does anyone have any ideas about how to do this using the Generic Hibernate DAO? Could this be done with a custom dialect perhaps?