헤르메스 LIFE

우분투에서 Oracle SQL 을 사용하기 위해 SQL Developer 를 설치했습니다. 환경 Oracle Cloud Database Free Tier 1. SQL Developer 다운로드 https://www.oracle.com/database/sqldeveloper/ SQL Developer Oracle SQL Developer is a free, development environment that simplifies the management of Oracle Database in both traditional and Cloud deployments. It offers development of your PL/SQL applications, query tools, a DBA console, a ..

Oracle Array 샘플 #1 DECLARE type employeeNames IS VARRAY(6) OF VARCHAR2(10); type salary IS VARRAY(6) OF INTEGER; names employeeNames; salaries salary; total integer; BEGIN names := employeeNames('Mayur', 'Ekta', 'Pari', 'Yashika', 'Payal'); salaries:= salary(9845, 9007, 7813, 8754, 9022); total := names.count; dbms_output.put_line('Total '|| total || ' Employees'); FOR i in 1 .. total LOOP dbms_..

Docker에 Oracle XE 를 설치할 예정입니다. ? oracle-xe 를 찾습니다. C:\>docker search oracle-xe NAME DESCRIPTION STARS OFFICIAL AUTOMATED gvenzl/oracle-xe Oracle Database XE (21c, 18c, 11g) for every… 211 oracleinanutshell/oracle-xe-11g 273 wnameless/oracle-xe-11g-r2 Oracle Express Edition 11g Release 2 on Ubun… 96 christophesurmont/oracle-xe-11g Clone of the wnameless/oracle-xe-11g. 7 pvargacl/oracle-xe-18.4.0 ..

Python 3.9 1. cx_Oracle 라이브러리 설치 (venv) C:\JetBrains\pythonProject\venv\Scripts>pip install cx_Oracle Collecting cx_Oracle Downloading cx_Oracle-8.1.0-cp39-cp39-win_amd64.whl (207 kB) |████████████████████████████████| 207 kB 819 kB/s Installing collected packages: cx-Oracle Successfully installed cx-Oracle-8.1.0 1. Oracle Connection Sample #1 import cx_Oracle #한글 지원 방법 import os os.putenv('NLS_..

Name of JDBC Driver : Driver Version : Major Version : Minor Version : Database Product Name : Database Product Version Version : Database Major Version: Database Minot Version:

테이블 정보( 테이블 Comment + 컬럼 Comment + PK ) + Camel 표기 SELECT A.COLUMN_NAME , SUBSTR(LOWER(A.COLUMN_NAME), 1,1) || SUBSTR(REPLACE(INITCAP(A.COLUMN_NAME), '_'), 2) AS INIT_COL_CAP_NAME , B.COMMENTS , CASE WHEN LENGTH(C.INDEX_NAME) > 0 THEN 'PK' ELSE '' END AS PK_DIV , D.COMMENTS TABLE_COMMENTS FROM ALL_TAB_COLUMNS A , ALL_COL_COMMENTS B , ALL_IND_COLUMNS C , ALL_TAB_COMMENTS D WHERE A.TABLE_NAME = B...

참고 : http://tylee82.tistory.com/116 export를 실행하는데 아래와 같은 에러가 발생하였다. [oracle@CentOS5DBserver ~]$ exp ID/pwass@TEST_SERVERfile=TESTDB090617.dmp log=TESTDB090617.log Export: Release 9.2.0.4.0 - Production on Tue Jun 16 09:24:42 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP ..

중복기간 체크 SELECT CASE WHEN EXISTS ( SELECT 1 FROM CHECK_TABLE WHERE KEY0 = 'KEY0' AND KEY1 = 'KEY1' AND STA_YMD '시작일' AND STA_YMD = '시작일' ) THEN 'Y' ELSE 'N' END DUP_YN FROM DUAL

-- 전일 SELECT TO_CHAR(SYSDATE - 1, 'YYYYMMDD') FROM DUAL; -- 현재주 SELECT TO_CHAR(SYSDATE, 'WW') FROM DUAL; -- 지난주 SELECT TO_CHAR(SYSDATE -7, 'WW') FROM DUAL; -- 현재월 SELECT TO_CHAR(SYSDATE, 'YYYYMM') FROM DUAL; -- 현재분기 SELECT TO_CHAR(SYSDATE, 'q') FROM DUAL; -- 반기 SELECT CEIL(TO_CHAR(SYSDATE, 'q') / 2) FROM DUAL;

테이블 생성일자 확인 SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE' AND OBJECT_NAME LIKE 'TE%' AND CREATED > TO_DATE('20160301', 'YYYYMMDD')