5 Replies Latest reply on Nov 4, 2016 3:39 PM by Gunther Pippèrr

    SQLcl 4.2 – SQLcl Prompt set with  “_USER”  changed by define a variable

    Gunther Pippèrr

      Hello Team,

       

      with the new version of  SQLcl: Release 4.2.0.16.131.1023 I have the following effect if I set the prompt with “set sqlprompt "_USER>" AND use define to set the value of a variable.

       

      SQL>

      SQL> set sqlprompt "_USER>"

       

      SYS>

       

      SYS>define y=##YYY##

       

      S##YYY##S>

       

      S##YYY##S> define s=XXXX

       

      XXXX##YYY##XXXX>

       

      and so on

       

       

      Best Regards

      Gunther