3 ms·
I'm not sure that's correct. AFAIK, having deep Oracle knowledge is very valuable to the right employer, but not so much for non-Oracle shops. From my experie
by CoastalCoder 3y ago
I'm not sure that's correct. AFAIK, having deep Oracle knowledge is very valuable to the right employer, but not so much for non-Oracle shops.
From my experience ~20 years ago, Oracle and SQL Server were very different beasts.
IIRC, once you get past trivial querying and into storage design, query optimization, etc., they're very different beasts. And Oracle in particular is it's own, huge world at that level. (Again, if I recall correctly.)
- Archimedes_52 3y agoI work with both Oracle and SQL Server, and this is absolutely true. There is a common standard you can stick to, but there is also a considerable universe of Oracle-specific features even just in the query language, to say nothing of temp tables etc.
- jmye 3y agoSure, and I think that would definitely be relevant to a different kind/level of analyst. Sounds like OP’s mom would be more than covered by knowing how to google “Postgres function for whatever”. I think for most SQL-only analysts, the vagaries of deep Oracle vs. MSSQL or whatever aren’t super relevant.
- cafard 3y agoMy own impression is that she who can write PL/SQL can write T-SQL. My own background is largely in Oracle, but I've dealt with SQL Server a fair bit.