SH@ao61 14:26:01>declare
  2    n number := 10000000;
  3    s nvarchar2(32000 char);
  4    p nvarchar2(3 char) := '%q%';
  5    --s varchar2(32000);
  6    --p varchar2(3) := '%q%';
  7    cnt number := 0;
  8  begin
  9    s:=rpad('q', 16000);
 10    for i in 1..n loop
 11      if s like p then
 12        cnt := cnt+1;
 13       end if;
 14    end loop;
 15    dbms_output.put_line(cnt);
 16  end;
 17  /
10000000

Elapsed: 00:00:00.51

SH@ao61 14:04:32>declare
  2    n number := 10000000;
  3    s nvarchar2(4000);
  4    cnt number := 0;
  5  begin
  6    s:=rpad('q', 4000);
  7    for i in 1..n loop
  8      if s like '%q%' then
  9        cnt := cnt+1;
 10       end if;
 11    end loop;
 12    dbms_output.put_line(cnt);
 13  end;
 14  /
10000000

PL/SQL procedure successfully completed.

Elapsed: 00:01:29.90

set stat on;
set term ^;
execute block returns(cnt int) as
declare n int = 10000000;
declare s varchar(50) character set utf8;
declare p varchar(3) character set utf8;
begin
cnt=0;
s=rpad('q',50,' ');
 p ='%q%';
while (n>0) do begin
  cnt = cnt + iif( s like  p , 1, 0);
  n=n-1;
end
  suspend;
end^
set term ;^
set stat off;

set stat on;
set term ^;
execute block returns(cnt int) as
declare n int = 10000000;
declare s varchar(50) character set utf8;
--declare p varchar(3) character set utf8;
begin
cnt=0;
s=rpad('q',50,' ');
--p='%q%';
while (n>0) do begin
  cnt = cnt + iif( s like  '%q%' , 1, 0);
  n=n-1;
end
  suspend;
end^
set term ;^
set stat off;

Usage: javac <options> <source files>
where possible options include:
  -g                         Generate all debugging info
  -g:none                    Generate no debugging info
  -g:{lines,vars,source}     Generate only some debugging info
  -nowarn                    Generate no warnings
  -verbose                   Output messages about what the compiler is doing
  -deprecation               Output source locations where deprecated APIs are used
  -classpath <path>          Specify where to find user class files and annotation processors
  -cp <path>                 Specify where to find user class files and annotation processors
  -sourcepath <path>         Specify where to find input source files
  -bootclasspath <path>      Override location of bootstrap class files
  -extdirs <dirs>            Override location of installed extensions
  -endorseddirs <dirs>       Override location of endorsed standards path
  -proc:{none,only}          Control whether annotation processing and/or compilation is done.
  -processor <class1>[,<class2>,<class3>...]Names of the annotation processors to run; bypasses default discovery process
  -processorpath <path>      Specify where to find annotation processors
  -d <directory>             Specify where to place generated class files
  -s <directory>             Specify where to place generated source files
  -implicit:{none,class}     Specify whether or not to generate class files for implicitly referenced files 
  -encoding <encoding>       Specify character encoding used by source files
  -source <release>          Provide source compatibility with specified release
  -target <release>          Generate class files for specific VM version
  -version                   Version information
  -help                      Print a synopsis of standard options
  -Akey[=value]              Options to pass to annotation processors
  -X                         Print a synopsis of nonstandard options
  -J<flag>                   Pass <flag> directly to the runtime system

Usage: java [-options] class [args...]
           (to execute a class)
   or  java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM  [deprecated]
                  The default VM is client.
                  
    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion  print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                    see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument
    -splash:<imagepath>
                  show splash screen with specified image