Recent content by Odd Harry Ophaug

  1. O

    Select with inline function fails in SQL and Command Window

    Sorry for the late reply: Yes, the inline function works fine in a test window. /Odd Harry
  2. O

    Select with inline function fails in SQL and Command Window

    I have tried both check and uncheck AutoSelect in my prefs. Marking the whole statement does not work either.
  3. O

    Select with inline function fails in SQL and Command Window

    In Oracle 12c we can write inline functions within a select statement. When running such a select in SQL or Command Window, the statement is broken into several pieces. A simple example: with function IC (a_ in varchar2) return varchar2 is begin return initcap(a_); end; select IC(username)...
See more
Back
Top