title: Oracle function based index using LTRIM?
body: <p>Anyone created a function based index in oracle using LTRIM. Can you only use it with LTRIM function name and without the position parameter. I can create it like below, but not with a position parm.</p>
  
  <pre><code>CREATE INDEX GIS1.IX_GIS_DOCVERSION_FUNCTION_02
      ON GIS1.DOCVERSION(LTRIM("UBAB8_ORDERNUMBER")
  )
  TABLESPACE TS_GIS1
  LOGGING
  PCTFREE 10
  INITRANS 2
  MAXTRANS 255
  STORAGE(INITIAL 64K
          BUFFER_POOL DEFAULT)
  NOPARALLEL
  NOCOMPRESS
  /
  </code></pre>