How to check the SRID of my table - ORACLE

Question

I have tables, but I need to know what SRID has. I tried to search the web, but I can't find how. I am starting with Oracle. Thank you

Answer 1

The answer from Littlefoot is correct, but it will show you the SRID of only one row. There is no guarantee that all rows have the same SRID (this is something you must enforce).
So, I would drop the "where rownum = 1" clause and would use group by:

select s.geom.sdo_srid, count(*)  
from objekt_stup s  
group by s.geom.sdo_srid ;