Where The Streets Have No Name

참고 : Eclipse WTP + Tomcat5.5 defaultContext 설정 wtp상의 서버설정을 tomcat으로 해서 start를 하면 tomcat에 기본적으로 설정된 root context의 페이지들을 접근하지 못합니다. 그래서 새로운 project를 만들어서 새로운 context를 설정해서 시작해야합니다. 마지막으로 프로젝트를 add해야만 정상적인 접근이 가능합니다. http://localhost:8080/으로 접속

출처 : 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..