Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting ORA-00933: SQL command not properly ended, when running the following query?

Status
Not open for further replies.

jsmith01

Technical User
Oct 15, 2006
2
0
0
US
SELECT filtered.geom FROM (
select * from buildings b
where sdo_FILTER(b.geom,
sdo_geometry( 2003, null, null, sdo_elem_info_array(1,1003,3), sdo_ordinate_array( 50,50, 400, 400) ) ) = 'TRUE'
) as filtered
WHERE sdo_NN( filtered, sdo_geometry(2001, null, sdo_point_type(200,200,null),null,null), 'sdo_num_res=1') = 'TRUE';

Any idea what is wrong? I checked many times, all bracers are matched, as you can see
 
Remove the 'AS' from "AS filtered"
[noevil]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top