So, I could easily do this in SQL Server. I created a cursor, but to be even more simple, I just ran SP_MSFOREACHDB
with a simple query:
select top 1 * from Database..Table order by Date desc
I created a global temp table, and populated it with the data of the select.
But, How can I do this on oracle?
I tried with cursors, union, and creating some loops but as a SQL Server DBA, I'm pretty bad with PL-SQL.
So, How can I run a simple select over all users? Cursor? Loops? create all selects and use union ?
Thanks.
Best Answer
You need the DBA role or similar access to select from this table. In Oracle 12 the columns available are