title: Oracle sql: is there a way to compose queries using aliases for entire clauses?
body: <p>Analyzing an Oracle DB of an application of mine, I always run queries ending with the very same "order by" clause, given that every table has a date type "DT_EXTRACTION" column.</p>
  
  <p>Is there a way to define an alias for String "order by DT_EXTRACTION desc" (say, equals to $DD) and write my query like this?</p>
  
  <pre><code>select *
  from foo
  $DD;
  </code></pre>