rem
rem $Header: utlxplan.sql big_dev/0 11-aug-95.14:02:45 achaudhr Exp $ xplainpl.sql
rem
Rem Copyright (c) 1988, 1995, 1996, 1998 by Oracle Corporation
Rem NAME
REM UTLXPLAN.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem mzait 02/19/98 - add distribution method column
Rem ddas 05/17/96 - change search_columns to number
Rem achaudhr 07/23/95 - PTI: Add columns partition_{start, stop, id}
Rem glumpkin 08/25/94 - new optimizer fields
Rem jcohen 11/05/93 - merge changes from branch 1.1.710.1 - 9/24
Rem jcohen 09/24/93 - #163783 add optimizer column
Rem glumpkin 10/25/92 - Renamed from XPLAINPL.SQL
Rem jcohen 05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef)
Rem rlim 04/29/91 - change char to varchar2
Rem Peeler 10/19/88 - Creation
Rem
Rem This is the format for the table that is used by the EXPLAIN PLAN
Rem statement. The explain statement requires the presence of this
Rem table in order to store the descriptions of the row sources.
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operation varchar2(30),
options varchar2(30),
object_node varchar2(128),
object_owner varchar2(30),
object_name varchar2(30),
object_instance numeric,
object_type varchar2(30),
optimizer varchar2(255),
search_columns number,
id numeric,
parent_id numeric,
position numeric,
cost numeric,
cardinality numeric,
bytes numeric,
other_tag varchar2(255),
partition_start varchar2(255),
partition_stop varchar2(255),
partition_id numeric,
other long,
distribution varchar2(30));
select b.emp_no, b.emp_nm, a.GRP_CD from a a, b b
where a.emp_no(+) = b.emp_no
and a.emp_no = 'a'
rem $Header: utlxplan.sql big_dev/0 11-aug-95.14:02:45 achaudhr Exp $ xplainpl.sql
rem
Rem Copyright (c) 1988, 1995, 1996, 1998 by Oracle Corporation
Rem NAME
REM UTLXPLAN.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem mzait 02/19/98 - add distribution method column
Rem ddas 05/17/96 - change search_columns to number
Rem achaudhr 07/23/95 - PTI: Add columns partition_{start, stop, id}
Rem glumpkin 08/25/94 - new optimizer fields
Rem jcohen 11/05/93 - merge changes from branch 1.1.710.1 - 9/24
Rem jcohen 09/24/93 - #163783 add optimizer column
Rem glumpkin 10/25/92 - Renamed from XPLAINPL.SQL
Rem jcohen 05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef)
Rem rlim 04/29/91 - change char to varchar2
Rem Peeler 10/19/88 - Creation
Rem
Rem This is the format for the table that is used by the EXPLAIN PLAN
Rem statement. The explain statement requires the presence of this
Rem table in order to store the descriptions of the row sources.
create table PLAN_TABLE (
statement_id varchar2(30),
timestamp date,
remarks varchar2(80),
operation varchar2(30),
options varchar2(30),
object_node varchar2(128),
object_owner varchar2(30),
object_name varchar2(30),
object_instance numeric,
object_type varchar2(30),
optimizer varchar2(255),
search_columns number,
id numeric,
parent_id numeric,
position numeric,
cost numeric,
cardinality numeric,
bytes numeric,
other_tag varchar2(255),
partition_start varchar2(255),
partition_stop varchar2(255),
partition_id numeric,
other long,
distribution varchar2(30));
select b.emp_no, b.emp_nm, a.GRP_CD from a a, b b
where a.emp_no(+) = b.emp_no
and a.emp_no = 'a'
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
86 | 수식이용 | 운영자 | 2002.09.18 | 2566 |
85 | 다수 NULL 허용 COLUMN의 명칭을 가져올때 | 운영자 | 2002.09.18 | 3572 |
84 | DATA 병합 | 운영자 | 2002.09.18 | 2405 |
83 | 최대값과 해당해의 다른값 가져오기 | 운영자 | 2002.09.18 | 3051 |
82 | 행렬(matrix)계산을위한 준비 | 운영자 | 2002.09.18 | 2887 |
81 | 부등호 조인 | 운영자 | 2002.09.18 | 56559 |
80 | 그룹 단위별 일련번호 붙이기 | 운영자 | 2002.09.18 | 5668 |
79 | 누계를 구하는 또한가지 방법 | 운영자 | 2002.09.18 | 2925 |
78 | 최대값과 최소값을 뺀 평균 | 운영자 | 2002.09.18 | 3941 |
77 | COLUMN을 ROW로 | 운영자 | 2002.09.18 | 5858 |
76 | 석차구하기 | 운영자 | 2002.09.18 | 2862 |
75 | 소계/합계 함께 보기 | 운영자 | 2002.09.18 | 2988 |
74 | 동일한 값 안보여주기 | 운영자 | 2002.09.18 | 2778 |
73 | PAIRWISE 와 NONPAIRWISE | 운영자 | 2002.09.18 | 2597 |
72 | PARAMETER값 변경에따른 유연한 GROUP BY | 운영자 | 2002.09.18 | 4040 |
71 | DATA COPY를 이용한 QUERY | 운영자 | 2002.09.18 | 3035 |
70 | 자기보다 작은값중 최대값 하나만 읽어오기 | 운영자 | 2002.09.18 | 4460 |
69 | 누계 COLUMN이 없는 TABLE에 누계 값을 보자 (IN-LINE VIEW) | 운영자 | 2002.09.18 | 3090 |
68 | 바로이전 ROW의 값을 참조하고자 할때 | 운영자 | 2002.09.18 | 8493 |
67 | 누계 COLUMN이 없는 TABLE에 누계 값을 보자 (부등호 JOIN) | 운영자 | 2002.09.18 | 4927 |