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

<og:query command="NEW" notfoundMsg=" " useBeforeHtmlTag="false" scope="request">
	SELECT 	 ENAME
			,SAL
			,ROUND(SAL * 2 * DBMS_RANDOM.VALUE) as SALES
			,ROUND(SAL * 2 * DBMS_RANDOM.VALUE) as AMOUNT
	FROM EMP
	order by ENAME
</og:query>

<og:view
	viewFormType	= "JSON"
	command			= "NEW"
	scope			= "request"
	useHilightRow	= "false"
	useAfterHtmlTag = "false"
	useConsistency	= "false"
	pageSize		= "1000"
/>

</jsp:root>
