이응기역

addDataset

public void addDataset(Dataset ds)

Dataset을 추가한다. 

Parameters:

ds - Dataset

 

(http://203.237.168.31:8080/docs/Miplatform310_JavadocAPI/com/tobesoft/platform/data/class-use/Dataset.html)

miplaform dev-on flow

<< UI >>

miplatform ->

<<WAS>>

[Channel]

miplatform channel servlet -> *CMD ->

 miplatform channel servlet -> navigation manager -> Navigation.xml

[Busieness]

BDExecutor -> *BD -> *CTR ->

[Persistent]

Common DAO -> *Queryxml

chrome 아이콘 -> 오른쪽 마우스 -> 설정 -> 대상(T)

에서 명령행 수정

" ....... chrome.exe" 

-->

" ....... chrome.exe"  --allow-outdated-plugins

select * from TABLES where table_name like '%ABC%'

* 에러가 나는 경우

SELECT 1 FROM

(SELECT 1);

* 조치 : subquery 에 alias 를 붙인다

SELECT 1 FROM

(SELECT 1) AS FOO --   <-- AS ... 

;

http://download.cnet.com/Vim/3055-2352_4-10525454.html?tag=pdl-redir

http://sourceforge.net/projects/cream/files/

http://www.baremetalsoft.com/baretail/index.php

http://sourceforge.net/projects/tailforwin32/

http://stackoverflow.com/questions/187587/looking-for-a-windows-equivalent-of-the-unix-tail-command

조인(join) 순서를 지시하는 힌트(hint)

보기:

SELECT /*+ LEADING(e2 e1) USE_NL(e1) INDEX(e1 emp_emp_id_pk) 
           USE_MERGE(j) FULL(j) */
    e1.first_name, e1.last_name, j.job_id, sum(e2.salary) total_sal
  FROM employees e1, employees e2, job_history j
  WHERE e1.employee_id = e2.manager_id
    AND e1.employee_id = j.employee_id
    AND e1.hire_date = j.start_date
  GROUP BY e1.first_name, e1.last_name, j.job_id
  ORDER BY total_sal;

http://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm

아래 글도 참고

http://www.dbguide.net/db.db?mobile&cmd=view&boardUid=148222&boardConfigUid=9&categoryUid=216&boardIdx=140&boardStep=1

http://www.dbguide.net/db.db?cmd=view&boardUid=148218&boardConfigUid=9&categoryUid=216&boardIdx=139&boardStep=1

* query 실행 : CTRL + ENTER

* 주석 : --