Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to run a simple query mentioned on: http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_operat.htm#g996876

SELECT c.mkt_id, c.name
  FROM cola_markets c
  WHERE SDO_COVEREDBY(c.shape,
            SDO_GEOMETRY(2003, NULL, NULL,
              SDO_ELEM_INFO_ARRAY(1,1003,3),
              SDO_ORDINATE_ARRAY(1,1, 5,8))
            ) = 'TRUE';

The records are there in the database satisfying the covered by condition, but they are not getting displayed.

share|improve this question

migrated from academia.stackexchange.com Mar 30 '14 at 19:29

This question came from our site for academics and those enrolled in higher education.

6  
This question appears to be off-topic because it is not about Academia. – scaaahu Mar 30 '14 at 8:09
    
sorry but I am new to stackflow account. I didn't get the oracle tag. – Siddhi Mar 30 '14 at 17:10
    
@Siddhi This wasn't closed because it had the wrong tag; it was closed because this is the wrong stack exchange site for this kind of question. Try asking on one of the sites Ben Norris mentioned. – ff524 Mar 30 '14 at 17:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.