title: Oracle APEX 4.2 How to store string and access from any page?
body: <p>I'm a complete noob and have only been learning this since last night.</p>
  
  <p>I have an APEX application with a few forms and reports that I have managed to get working correctly if I provide the exact SQL statement in the source box. What I want to do is be able to set a variable that I can access from any page.</p>
  
  <p>I want to be able to return its value to use in my SQL source clause in my forms when the pages load and I also want to be able to assign its value maybe via a process, branch or button (i'm still learning what they are propperly) on any page.</p>
  
  <p>I've been at this for hours now and the tiny amount of help I can find on this is completely beyond me and its driving me mad, so if anyone can help me figure out how to do this it would be hugely appreciated.</p>