3 ms·
Oh man, in theory SQL is standard - in practice, you’ll need to rewrite (or do major surgery) on nearly everything that interacts with your Oracle instance. Unl
by lazide 3y ago
Oh man, in theory SQL is standard - in practice, you’ll need to rewrite (or do major surgery) on nearly everything that interacts with your Oracle instance. Unless you’ve been incredibly careful, which is unlikely.
And chances are, you started using Oracle because of some enterprise software somewhere for which you don’t even have the source - so good luck.
And don’t forget, Oracle will encourage you to use all their Oracle specific stuff everywhere in their documentation. It’s a giant, idiosyncratic mess.
- SoftTalker 3y agoIf you were using SQL so generically that you could easily substitute another database, you never should have been using Oracle to begin with. I guess you could call it "vendor lock-in" to use the more advanced SQL, analytic functions, and stored procedures or you could call it "getting what you paid for."
- icedchai 3y agoIt's similar to the cloud lock-in you see today. (If all you're using is VMs, you're probably better off with something else...)