<?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	= "ORA10"
	title	= "DBオブジェクト内容"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">
<table summary="layout" >
    <tr>
		<og:column name="DBID" codeKeyVal="{@DBID_INFO}" onChange="renew('query.jsp','QUERY');" />
		<og:column name="OWNER" aimai="V*" size="10" editor="DATALIST" dbid="{@DBID}"
			param="select username from dba_users where ACCOUNT_STATUS='OPEN' order by username"
		/>
		<og:column name="OBJECT_NAME" aimai="V*" />
		<og:select name="STATUS"	 >
			<og:option lbl="VALID"   value="VALID" />
			<og:option lbl="INVALID" value="INVALID" />
		</og:select>
	</tr>
</table>
<table summary="layout" >
	<tr>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="table"        value="TABLE"		/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="view"         value="VIEW"		/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="index"        value="INDEX"		/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="trigger"      value="TRIGGER"	/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="sequence"     value="SEQUENCE"	/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="synonym"      value="SYNONYM"	/>
	</tr>
	<tr>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="function"     value="FUNCTION"	/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="package"      value="PACKAGE"	/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="package body" value="PACKAGE BODY" />
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="procedure"    value="PROCEDURE"	/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="type"         value="TYPE"		/>
		<og:input type="checkbox" name="OBJECT_TYPE" lbl="type body"    value="TYPE BODY"	/>
	</tr>
</table>

<fieldset style="display:inline;">
	<legend><strong><og:message lbl="Difference" /></strong></legend>
	<table><tr>
	<og:column name="TO_DBID"	codeKeyVal="{@DBID_INFO}" onChange="renew('query.jsp','QUERY');" />
	<og:column name="TO_OWNER" aimai="V*" size="10" editor="DATALIST" dbid="{@TO_DBID}"
		param="select username from dba_users where ACCOUNT_STATUS='OPEN' order by username"
	/>
	<og:select name="choice" lbl="CHOICE">
		<og:option value=""           lbl=""           />
		<og:option value="MINUS"      lbl="Minus"      />
		<og:option value="INTERSECT"  lbl="Intersect"  />
		<og:option value="DIFFERENCE" lbl="Difference" />
	</og:select>
	</tr></table>
</fieldset>

<og:queryButton>
	<og:select name="ORDER_BY" lbl="ORDER_BY" td="no">
		<og:option value="OWNER,OBJECT_NAME,OBJECT_TYPE"	lbls="OWNER,NAME,TYPE" />
		<og:option value="OWNER,OBJECT_TYPE,OBJECT_NAME"	lbls="OWNER,TYPE,NAME" />
		<og:option value="OBJECT_NAME,OBJECT_TYPE,OWNER"	lbls="NAME,TYPE,OWNER" />
		<og:option value="OBJECT_TYPE,OBJECT_TYPE,OWNER"	lbls="TYPE,TYPE,OWNER" />
	</og:select>
</og:queryButton>
</form>

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