SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check data types of columns from large query

3323435Oct 2 2016 — edited Oct 3 2016

Hi I have a very large query which is over 90 lines in length, which has been passed to me.

I am trying to perform a MINUS on the result set of this query with a result set from another table.. I am not sure, however that it is giving me the correct result.

To test it I limited both the query and the table to the same 2 rows and performed the MINUS operation, expecting 0 rows displayed. I still got 2 rows showing, so wondered if this is because data types diff between the query and the table?

Is there a way to check the data types of each column of the large query after running it in SQL developer?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2016

Added on Oct 2 2016

14 comments

41,185 views