Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 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 at 8:09
    
sorry but I am new to stackflow account. I didn't get the oracle tag. –  Siddhi Mar 30 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 at 17:43

Your Answer

 
discard

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