일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
- node.js
- WebLogic
- 선택적조인
- JSON
- tomcat
- appspresso
- Eclipse
- JDOM
- PLSQL
- phonegap
- MySQL
- Spring
- 가우스
- rowspan
- swingx
- iBATIS
- GPS
- dock
- sencha touch
- Android
- MFC
- oracle
- 전자정부프레임워크
- Ajax
- PHP
- jQuery
- jsr 296
- ibsheet
- Google Map
- Struts
- Today
- Total
목록Developement/DataBase (109)
Where The Streets Have No Name
출처 : http://www.oracleappshub.com/api/oracle-api-availability-concurrent-program/ Many times, we need to submit concurrent requests and request sets from non SRS window like operating system or PL/sql . In Oracle Applications there are API’s to take these options. Here are some of the API’s function and usage.. FND_REQUEST This API is used Submit concurrent requests from backend. As we know th..
출처 : http://orabiz.blogspot.com/2007/07/fndrequestsubmitrequest-handy-tip.html Here is a HANDY TIP that could save you some time bugging why the fnd_request.submit_request procedure is returning a request_id of 0. If you are creating and running a package to run outside Oracle Applications, you may be wondering why the procedure will not be executing your concurrent program being passed into int..
출처 : http://www.뜨레.kr/zboard/view.php?id=plsql&page=3&sn1=&divpage=1&sn=off&ss=on&sc=on&select_arrange=headnum&desc=desc&no=43
출처 : http://www.toadworld.com/Community/Blogs/tabid/67/EntryID/280/Default.aspx Ihave generally recommended in the past that whenever you are writingcode to iterate through the elements of a collection, you should use awhile loop, combined with the FIRST-NEXT or LAST-PRIOR collectionmethods. The key advantage of this approach is that the code will not raisea NO_DATA_FOUND exception if your colle..
출처 : http://www.oracleclub.com/article/13624 --실수로 지운 데이터 살리기.. 예 kfm08ot1이라는 테이블의 bnk_cd ='04' 인 데이터를 실수로 삭제를 했다. commit; 도 완료된 상태라면.. 앞이 막막할것이다. 이럴땐 이렇게 데이터를 불러보자.. SELECT * FROM KFM08OT1 as of timestamp ( systimestamp - interval '10' minute) where bnk_cd = '04' 조회후 파일을 txt나 엑셀로 저장후.. 다시 임포트 해야 합니다.
출처 : http://extremedb.blogspot.com/2008/05/lateral-view.html Lateral View와 아우터조인의 개념에 대해서는 이미 언급이 되었고 이번에는 Lateral View 를 이용한 튜닝에 대하여 알아보기로 한다. 먼저 개발자들에게 받는 질문 상위 10개 중에 항상 들어있는 질문이 있다. "선택적으로 조인하는 기능이 오라클에 있습니까?" 필자는 항상 다음과 같이 답변한다. "있습니다." 아래 모델을 보자. 이모델을 보면 고객유형(subtype) 에 따라서 개인기본으로 조인할지 사업자기본으로 조인할지 결정이 되는것이다. 물론 연락처기본은 고객기본과 항상 1:1 이다. 이런 모델에서 대부분의 개발자는 아래와 같은 SQL 을 작성한다. SELECT A.고객번호, A...
출처 : http://blog.naver.com/inter999/140048698535 아래와 같은 Query을 Function으로 만들어서 Return 해야 한다면 일반적인 oracle datatype으로는 Table 형태의 결과를 Return 할 수 없고 User Defined Object을 생성하여 사용하면 된다. select d.DEPTNO, d.DNAME, e.EMPNO, e.ENAME from dept d, emp e where d.DEPTNO = e.DEPTNO 실행결과(간략) DEPTNO DNAME EMPNO ENAME 20 RESEARCH 7369 SMITH 30 SALES 7499 ALLEN 30 SALES 7521 WARD 20 RESEARCH 7566 JONES 30 SALES 76..
출처 : 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://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..