Always loved his music. I went by myself to see him in concert about 30 years ago because I didn't know anyone else into him at the time.

My education was mainframe but my first six years of programming was on PDP's, MicroVAX, etc. Unfortunately it was mostly programming in DIBOL, lol.

I liked working on VMS and DCL. That's the environment my first programming job was in. Scott

I saw them on that tour in Connecticut, sixth row from the stage, right in the center. Awesome show. Scott

I confess I use SQL Server more these days than Oracle, but the only possible option I can find that would let you see multiple databases seems to be if you're using something like Enterprise Manager Cloud Control - [Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository - My DBA World]([https://www.mydbaworld.com/extract-databases-server-os-version-of-oem-repository/\])

In Oracle, the equivalent for SQL Server's information_schema or sys tables would be the DICTIONARY and dynamic performance views - ([https://docs.oracle.com/cd/E11882\_01/server.112/e40540/datadict.htm#CNCPT002\](https://docs.oracle.com/cd/E11882\_01/server.112/e40540/datadict.htm#CNCPT002)) Your first query doesn't make sense in an Oracle context since in Oracle you only connect to one database at a time. The second could be (to list the tables in the connected database): SELECT * FROM ALL_TABLES; SELECT * FROM DBA_TABLES; depending on your rights. See the link for the difference.

I find Robert Sheldon's articles to be excellent, e.g. [Working with Window Functions in SQL Server - Simple Talk](https://www.red-gate.com/simple-talk/databases/sql-server/learn/working-with-window-functions-in-sql-server/)

I always find Robert Sheldon's articles to be excellent, e.g. [[^]Working with Window Functions in SQL Server - Simple Talk](https://www.red-gate.com/simple-talk/databases/sql-server/learn/working-with-window-functions-in-sql-server/)

Or the husband. Both just to be sure. ;-) Scott

Guitar

I started out on the PDP-11 but it was with DIBOL. Scott

I'm in Connecticut, currently forecast to get a foot+. Ugh. Scott

I saw them twice in concert in the mid 80's. Awesome concerts. Scott

And I was just using it myself - gawk anyway, both in Cygwin and in Gow ([Home · bmatzelle/gow Wiki · GitHub](https://github.com/bmatzelle/gow/wiki)) since I was on Windows. I was totaling up some fields in some CSV's.

I saw him just last year at a free show at a casino and I was impressed at the show he put on. :( Scott

Wishes for a speedy recovery. For my sh*tty week, I tore my distal biceps tendon last Saturday. Just had repair surgery yesterday, now comes the post-surgery pain, PT, etc. Scott

Sadly, I chuckled. :)

I was just listening to Refuge from the same album not five minutes ago while driving. :thumbsup: Scott

I can sympathize. I've been "business" side for about seven years now, after being in IT for about 22 years, programming, DBA, tech lead, etc. Now whenever I contact the "help" desk with an issue or submit an IT request, I have to sit through explanations about things like how memory is important and used by all the applications. :doh: Scott

I was woken up once by my now-wife by her hitting me in the head. I said "what was that for??", and she replied, "That's what you get for stealing my sewing machine!". Dreams can be dangerous. Scott