이응기역

https://animal-park.tistory.com/83

 메뉴에서 Run - Run Configurations 클릭

Common으로 들어가서 Default에서 Other로 변경해준 뒤 UTF-8 로 변경합니다.

서버 (eg. Tomcat) 다시 기동 

파일>새로 만들기>PL/SQL 편집기

Try right clicking on a project that was connected, go to Team -> Share Project, select SVN (as opposed to CVS), and see if the wizard that
comes up will allow you to reconnect your project(s).

https://www.eclipse.org/forums/index.php/t/14897/

    declare
      type NumberVarray is varray(100) of NUMERIC(10);
      myArray NumberVarray;
    BEGIN
      myArray := NumberVarray(1,10,100,1000,10000);

      --myArray(1) := 2;

      for i in myArray.first..myArray.last
      loop
        dbms_output.put_line('myArray(' || i || '): ' || myArray(i));
      end loop;  
    end;

(https://stackoverflow.com/questions/3545379/oracle-pl-sql-arrays)

WITH ASSERT (G, N, N2) AS (
    SELECT  'SL',  2264,  2040 FROM DUAL
UNION ALL SELECT  'SH', 22634, 20380 FROM DUAL
)
SELECT
G AS  PRICE_GRADE      -- 등급
        ,N AS  COST -- 원가1       D4
        ,N2 AS COST2 -- 원가2       D4
FROM ASSERT;

$ cat 1
qwer 1234 #@!$

$ fmt -1 1
qwer
1234
#@!$

(https://unix.stackexchange.com/questions/169995/rows-to-column-conversion-of-file)

man fmt

FMT(1)                           User Commands                          FMT(1)

NAME
       fmt - simple optimal text formatter

SYNOPSIS
       fmt [-WIDTH] [OPTION]... [FILE]...

DESCRIPTION
       Reformat  each  paragraph  in  the FILE(s), writing to standard output.
       The option -WIDTH is an abbreviated form of --width=DIGITS.
...

procedure 의 DBMS_OUTPUT.PUT_LINE('CHECK1 1640');
dbeaver 설정 
컨트롤+시프트+O output탭으로 열고

CALL MYPROCEDURE(); 실행

(https://stackoverflow.com/questions/51520900/dbeaver-not-showing-dbms-output)

: 

ex.

SELECT * FROM MY_TABLE 
WHERE USE_YN = :USE_YN
;

https://mug896.github.io/bash-shell/index.html

        SLEEPTIME=$((RANDOM % 1000))
echo " sleep $SLEEPTIME secs ... "
sleep $SLEEPTIME;