Where The Streets Have No Name

출처 : http://claztec.net/2460706 참고 : http://www.okjsp.pe.kr/seq/112631 이클립스 사용중 발생하는 jvm terminated. exit code -1 로 시작하는 에러. 이클립스가 아에 열리지 않는다. 이전엔 윈도우가 충돌나서 jvm에 영향을 주어 발생하는 줄 알았는데 그게 아닌가 보다. eclipse폴더안의 ecilpse.ini파일을 수정해 주면 된다. -showsplash org.eclipse.platform --launcher.XXMaxPermSize 256M -vmargs -Dosgi.requiredJavaVersion=1.5 -Xms40m -Xmx512m 이 부분의 에서 --launcher.XXMaxPermSize 256M 를 삭제하면 된다...

http://oracle.anilpassi.com/oa-framework-tutorials-training-2.html

http://gyumee.egloos.com/1471952

출처 : http://www.dbguide.net/blog/post/post_view.jsp?urlid=y2k0314&cnum=14539&pnum=8633 참고 : merge enhancements in 10g ☞ MERGE - 한번에 조건에 따라 INSERT,UPDATE 가 가능합니다. - 해당 ROW가 있으면 UPDATE, 없으면 INSERT 문장이 실행 됩니다. ◈syntax) MERGE INTO target_table_name USING (table|view|subquery) ON (join condition) WHEN MATCHED THEN UPDATE SET col1 = val1[, col2 = val2…] WHEN NOT MATCHED THEN INSERT(...) VALUES(...) ME..

참고 : http://www.oracle-base.com/articles/8i/DIYDynamicViews.php The method described in this article is based on the DIY$: Do-It-Yourself Dynamic Views article found on the Oracle Magazine website. The example below allows the alert log to be read using SQL in a similar manner to the user_source view. First an object type is defined to hold each row of data: CREATE TYPE Alert_Row_Type AS OBJECT ..

참고 : http://forums.oracle.com/forums/thread.jspa?threadID=613194

SELECT SQL_ID, T.SQL_FULLTEXT, B.NAME BIND_NAME, B.VALUE_STRING BIND_STRING FROM V$SQL T JOIN V$SQL_BIND_CAPTURE B USING (SQL_ID) WHERE B.VALUE_STRING IS NOT NULL AND SQL_ID = '6zr5bx6zf51w7' ORDER BY B.NAME;

참고 : http://blogs.techrepublic.com.com/programming-and-development/?p=400 I’ve been working with Oracle databases for a little over a year now, and the part I really like best is PL/SQL. That’s their database programming language that lets you combine procedural code with SQL code. What I like most is that it lets you build your entire app in one place ? all the data selects and updates, all the..

참고 : http://www.oracle.com/technology/oramag/oracle/05-mar/o25plsql.html Tracing Lines By Steven Feuerstein Find and report your errors—by line number—in Oracle Database 10g. PL/SQL offers a powerful and flexible exception architecture. Of course, there is always room for improvement, and in Oracle Database 10g, exception handling takes a big step forward with the introduction of the DBMS_UTILIT..

참고 : http://theblasfrompas.blogspot.com/2008/02/variable-in-list-with-oracle-jdbc-and.html I always wanted to create a variable in list query using a single parameter and found that it wasn't possible with JDBC. SELECT * FROM DEPT WHERE like DEPTNO IN (?); Then I stumbled upon this on steve's blog, which he shows how he did it in ADF BC using a SQL function. http://radio.weblogs.com/0118231/stor..

참고 : http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php

jikgub_cd를 3으로 나누어서 나머지에 따라서 복제가 일어나게끔... 1 => 1개복제 2 => 2개복제 0 => 3개복제 SELECT MOD (TO_NUMBER (A.JIKGUB_CD), 3) AS COPY_CNT, B.RN, A.* FROM ORG201 A, (SELECT ROWNUM AS RN FROM DUAL CONNECT BY LEVEL

참조 : https://geraldonit.com/2007/09/27/bulk-collect-forall-vs-cursor-for-loop/ CREATE OR REPLACE PROCEDURE BULK_COLLECT_QUERY IS TYPE SOWNER IS TABLE OF VARCHAR2 (30); TYPE SNAME IS TABLE OF VARCHAR2 (30); TYPE STYPE IS TABLE OF VARCHAR2 (19); L_SOWNER SOWNER; L_SNAME SNAME; L_STYPE STYPE; BEGIN DBMS_OUTPUT.PUT_LINE ('Before Bulk Collect: ' || SYSTIMESTAMP); SELECT OWNER, OBJECT_NAME, OBJECT_TYP..

pl/sql에서 코드를 작성할때 참조합시다... BEGIN code EXCEPTION code END; BEGIN code LOOP; code EXCEPTION code END; END LOOP; END; BEGIN code LOOP; code BEGIN code EXCEPTION code END; END LOOP; END;

http://forums.oracle.com/forums/thread.jspa?threadID=608730 SQL> var N number SQL> exec :N := 4 PL/SQL-procedure is geslaagd. SQL> select lpad(' ',:N-i,' ') || ltrim(x) n 2 from dual 3 model 4 dimension by (1 i) 5 measures (cast('1' as varchar2(100)) x) 6 rules iterate(10000) until iteration_number = :N-1 7 ( x[for i from 2 to :N increment 1] = x[cv()] || 8 case 9 when iteration_number+1 exec :N..

http://www.oracle-developer.net/display.php?id=410 workaround to inserts SQL> DECLARE 2 3 TYPE subset_rt IS RECORD 4 ( empno emp.empno%TYPE 5 , ename emp.ename%TYPE 6 , hiredate emp.hiredate%TYPE 7 , deptno emp.deptno%TYPE ); 8 9 TYPE subset_aat IS TABLE OF subset_rt 10 INDEX BY PLS_INTEGER; 11 12 aa_subset subset_aat; 13 14 BEGIN 15 16 /* Some "source" data... */ 17 SELECT ROWNUM, owner, create..

http://forums.oracle.com/forums/thread.jspa?threadID=609947 with month as ( select trunc(sysdate,'mon')+rownum-1 any_dt from dual connect by level

SQL*Plus: Release 10.2.0.1.0 - Production on On Dec 13 23:36:15 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL> select 'yes' from dual where (sysdate-5,sysdate) overlaps (sysdate-2,sysdate-1); 'YE --- yes SQL> select 'yes' from dual where (-5,0) overlaps (-2,-1); select 'yes' from dual where (-5,0)..

출처 : http://forums.oracle.com/forums/thread.jspa?threadID=385558 create or replace function fewcols(n in number,t in varchar2) return sys_refcursor is str varchar2(1000); opt sys_refcursor; begin for i in (select column_name from all_tab_cols where table_name = t and column_id select fewcols(4,'EMP') from dual; FEWCOLS(4,'EMP') -------------------- CURSOR STATEMENT : 1 CURSOR STATEMENT : 1 EMPNO..

출처 : 엔코아컨설팅 PURPOSE SCOPE & APPLICATION KEY IDEA (KEY WORD : 이력관리,평잔,선분이력,BETWEEN JOIN) SUPPOSITION DESCRIPTION 이력을 관리하는 데이터에 대해서 대부분의 경우는 선분이력을 관리하는 것이 대부분의 경우이다. 하지만, 선분이력에서 어느 시점에 해당하는 건을 찾기는 매우 쉽다. 즉 다음과 같이 Between을 이용하여 찾으면 된다. ............. WHERE '20000901' BETWEEN A.START_DATE AND A.END_DATE ............. 하지만 실제 업무에서는 위와 같은 요구뿐만 아니라 어느 기간내에서 일어난 모든 건을 찾고자하는 경우가 존재하기 마련이다. 예를 들어, 은행업무에서 특정..