I have a table with a geometry column. Now how do I view the spatial data using MapViewer?
Go to the MapViewer home page, click on the demos link, then choose the jview.jsp demo. This is a simple utility that you can use to quickly view any spatial data stored in the database or created through Oracle Spatial’s functions (such as the result of an sdo_buffer operation). In the jview.jsp page, fill in a datasource name that you already defined, and then simply type a SQL query that will select the table’s geometries in the text area named “query 1”. Note: you should not end your query with ‘;’. Click on the Submit button, and a map showing the geometries you just selected will appear. The following screen shot shows a more sophisticated example of using jview.jsp, showing 3 queries involving two spatial tables: counties and cities. The first query simply selects all the geometries from the counties table where the state abbreviation is ‘AL’. The Second query selects all the major cities from the cities table where the state abbreviation is also ‘AL’. Note how you can also spec
