DECLARE BEGIN FOR i IN 1..10 LOOP DBMS_OUTPUT.PUT_LINE(i); END LOOP; END; DECLARE BEGIN FOR t1 IN (SELECT A1, A2 FROM [TABLE]) LOOP DBMS_OUTPUT.PUT_LINE(t1.A1); END LOOP; END;

WINDOW - 설정 - 편집기 - 데이터 편집기 - 표현방식show column description in header

SELECT C1, C2 INTO V_A1, V_A2 FROM [TABLE] INTO 는 여러 행를 리턴 받을 수 없음 데이터 확인 후 단일 행으로 변경 (SUM, MIN, MAX) 등을 이용할 수도 있음

SELECT * FROM [TABLE] WHERE NAME = '이름' UNION ALL SELECT * FROM [TABLE] AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE) WHERE NAME ='이름' SECOND MINUTE HOUR INSERT INTO [TABLE] SELECT * FROM [TABLE] WHERE NAME = '이름' UNION ALL SELECT * FROM [TABLE] AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE) WHERE NAME ='이름'

C:\Users\[USERNAME]\AppData\Roaming\DBeaverData\workspace6\General\.dbeaver OR %APPDATA%\DBeaverData\workspace6\General\.dbeaver data-sources.json

SELECT * FROM [TABLE] PARTITION([PARTITION]) WHERE [CONDITIONS]