블로그
- 3일차(11월2일) 성적 처리 _메뉴 버전 (콘솔 기반 최종) 처리 _메뉴 버전 (콘솔 기반 최종) --------------------------------------INSERT 쿼리 샘플 (쿼리 끝 부분에 ; 표시하지 말 것)INSERT INTO 쿼리 추가 ->합격, 불합격, 과락 출력 , CASE WHEN ((kor+eng+mat)/3 >= 60) AND (kor= 60) THEN '합격' ELSE '불합격' END
- [Maya demand an end to doomsday myth 지구 종말설의 진실? 마야인들 입열다.] A scene from the movie "2012" which depicts the end of world on December 21, 2012. government and tour groups on Wednesday of perpetuating the myth that their calendar foresees the imminent end
- 테이블 레코드 셋 사용 * FROM USERTABLE WHERE USER_NO = l_cur.USER_NO; USERTABLE_REC := NULL; --예1) 한건만 받을 경우 FETCH cur0 INTO ); END LOOP; CLOSE cur0; END;
- 프로시저에서 동적 쿼리 사용하는 방법 DUMMY, NOTE; EXIT WHEN P_CURSOR%NOTFOUND; INSERT INTO TAM_DUAL (T_DUMMY, T_NOTE) VALUES ( DUMMY, NOTE ); END LOOP; CLOSE P_CURSOR; COMMIT; END;
- SELECT 문에서 Cursor 사용하여 값 받아 내는 방법 END IF; ret_value := ret_value || col_vaule; END LOOP; CLOSE cur; RETURN ret_value; EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN RAISE; END RowsToColumns; --// 사용방법 SELECT RowsToColumns.......
- Tottenham Hotspur - The club that Bill made Alistair Griffin:Just Drive There is a star that lights the road Will it take me to the end well I light Take it to the edge where I have died a thousand times And maybe I could be the one To ride into
- 프로시저에서 배열, 커서 Type 사용 해 보자.. BEGIN -- 0부터 ~ 12까지 배열 초기화 FOR ICNT IN 0..12 LOOP ARRAY_VARCHAR(ICNT) := ''; ARRAY_NUMBER(ICNT) := 0; END - 커서 타입 사용 예 SQLQUERY := 'SELECT DUMMY FROM DUAL'; OPEN P_CURSOR FOR SQLQUERY; LOOP FETCH P_CURSOR INTO
- 영어를 한국말로 소리나는데로 읽어주세여 (급함!!) People crossed this ice bridge. they moved south into North and south Amerca. At the end of the ice age, there were people in all parts of North and sout.......
- Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison cassandra-vs-mongodb-vs-couchdb-vs-redis While SQL databases are insanely useful tools, their tyranny of ~15 years is coming to an end And it was just time: I can't even count the things that were forced into relational databases, but never
- Trade Deficit increases sharply in June This is an easy comparison because of the collapse in trade at the end of 2008 and into early 2009.
← 이전
10 페이지