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:

SELECT c.mkt_id,
  FROM cola_markets c
            SDO_GEOMETRY(2003, NULL, NULL,
              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 Mar 30 '14 at 19:29

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

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


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