Gentle Breeze

#include #include #include #define MAX_CNT 30 EXEC SQL BEGIN DECLARE SECTION; VARCHAR uid[80]; VARCHAR pwd[20]; VARCHAR db_string[20]; VARCHAR usr_pwd[80]; VARCHAR v_ent_dt[MAX_CNT][8+1]; VARCHAR i_mbrno[MAX_CNT][30]; VARCHAR v_name[MAX_CNT][14+1]; VARCHAR v_phone_num[MAX_CNT][30]; EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE SQLCA; int main() { int i = 0; int count = 0; int bfCount = 0; int e..

이 상황에서 자주 발생하는 Oracle Error Code 원문 - http://scruz.tistory.com/18 ORA-01002: fetch out of sequence ORACLE에서 제공하는 문서상의 원인과 해결방법은 아래와 같다. Cause: This error means that a fetch has been attempted from a cursor which is no longer vaild. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetchi..

- 원문 : http://donkey612.blog.me/70078012834 POSIX Basic Regular Expression!s Traditional Unix regular expression! syntax followed common conventions but often differed from tool to tool. The IEEE POSIX Basic Regular Expression!s (BRE) standard (released alongside an alternative flavor called Extended Regular Expression!s or ERE) was designed mostly for backward compatibility with the traditional..

DECLARE v_dt DATE; BEGIN v_dt := TO_DATE ('19010101', 'yyyymmdd'); LOOP EXIT WHEN v_dt > TO_DATE ('21001231', 'yyyymmdd'); INSERT INTO BIZ_DATE_13 (DT, WEEK_DAY, HOLIDAY_YN) VALUES (TO_CHAR(v_dt, 'yyyymmdd') , TO_CHAR(v_dt, 'd') , DECODE((TO_CHAR(v_dt, 'd')), '1', 'Y', -- 일요일 '2', 'N', '3', 'N', '4', 'N', '5', 'N', '6', 'N', '7', 'Y', -- 토요일 'Y')); -- Fault Value v_dt := v_dt + 1; END LOOP; COMM..

SELECT A.uniqueness , B.* FROM ALL_INDEXES A , ALL_IND_COLUMNS B WHERE a.index_name = b.index_name AND a.table_name = upper('XXXXX'); // 테이블명