<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld" 
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "ORA08"
	title	= "統計情報収集"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
<table summary="layout" >
<tr>
	<og:column name="TABLE_OWNER" defaultVal="{@SYS.SYSTEM_ID}" size="10" editor="DATALIST" dbid="{@DBID}" must="true"
			param="select username from dba_users where ACCOUNT_STATUS='OPEN' order by username"
	/>
	<og:column name="DBID" codeKeyVal="{@DBID_INFO}" onChange="renew('query.jsp','QUERY');" />
</tr>
<tr>
	<og:select name="TABLE_NAME" >
		<og:option lbl="" />
		<og:queryOption dbid="{@DBID}" addKey="true">
				SELECT TABLE_NAME
				FROM	SYS.DBA_TABLES
				WHERE	OWNER like '{@NVL.TABLE_OWNER @SYS.SYSTEM_ID}'
				AND		INSTR(TABLE_NAME,'$') &lt; 1
				ORDER BY TABLE_NAME
		</og:queryOption>
	</og:select>
	<og:select name="INDEX_NAME" >
		<og:option lbl="" />
		<og:queryOption dbid="{@DBID}">
				SELECT INDEX_NAME
				FROM	SYS.DBA_INDEXES
				WHERE	OWNER like '{@NVL.TABLE_OWNER @SYS.SYSTEM_ID}'
				ORDER BY INDEX_NAME
		</og:queryOption>
	</og:select>
</tr>
</table>
<og:queryButton />
</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
