|
Sander Rossel wrote: I've heard "Oracle has packages[^]", but I fail to see what's so great about that.
Think of them as namespaces, that usually helps. And complaining about the existence of access modifiers is just silly, how do you know it's only going to be your own software in the database.
Why do you think there are access modifiers in DotNet?
Sander Rossel wrote: Next to that Oracle doesn't support booleans/bits,
The bit IS a numeric type.
Sander Rossel wrote: Good luck with the documentation too, not nearly as comprehensive as SQL Server.
Unless there's some documentation outside of MSDN and Technet that I haven't found, that is simply not true.
Sander Rossel wrote: The only plausible thing I've heard so far is that Oracle is faster because it locks at cell level while SQL Server locks at row level and often escalates to locking an entire page (and and I've heard an Oracle user say SQL Server always locks entire pages).
There is no such thing as a page lock in Oracle. Oracle has row-level locks and table-level locks.
Sander Rossel wrote: But honestly, after hearing about how powerful Oracle is supposed to be I'm REALLY VERY disappointed now that I actually have to work with it. Actually, it depends on what you're doing, OLTP -> Oracle but when doing OLAP I'd say SQL Server has the upper hand.
But that would also be to simplified. It really depends.
Sander Rossel wrote: Oracle doesn't even handle CASING PROPERLY
So it's not case sensitive, but that's something you should be used to from VB.
|
|
|
|
|
Jörgen Andersson wrote: complaining about the existence of access modifiers is just silly I just don't think they're necessary in the database. And that a header file is the most obnoxious way to support it
When I first started using Oracle I've searched for a good hour trying to find some weird error, then found out I updated my function declaration in the body, but not the header...
Jörgen Andersson wrote: The bit IS a numeric type. Yes, but one that supports only two values and is correctly converted to bool in C# (and somewhat awkwardly in SSMS).
Jörgen Andersson wrote: Unless there's some documentation outside of MSDN and Technet that I haven't found, that is simply not true. Maybe I just don't know where to look
I keep ending up on oracle.com, but so far I haven't been able to find what I'm looking for (then again, searching for table variables in Oracle isn't going to give you what you're looking for).
Jörgen Andersson wrote: So it's not case sensitive, but that's something you should be used to from VB. At least VB doesn't convert EVERYTHING TO UPPER CASE for me
The casing is the least of my problems though. I just wonder why they can't simply support RegularCasing in 2016.
|
|
|
|
|
Slacker007 wrote: schemas (oracle)
SQL Server has schemas too[^].
They used to be tied to user accounts in SQL 2000, but that was fixed in SQL 2005[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
As I understand a schema in Oracle is more like a separate database in SQL Server and a schema like in SQL Server doesn't exist in Oracle.
|
|
|
|
|
You probably could use schemas in SQL Server the same as they're used in Oracle, it's just that no one does because it's so easy to create a new database.
|
|
|
|
|
Schema is used for example to define an ownership and to separate logically different components into separate areas, in both systems. A separate database in SQL Server is very different from schema.
|
|
|
|
|
Exactly. Correct me if I am wrong, but it is usually just "one" database in Oracle with nNumber of schemas.
|
|
|
|
|
Usually yes, you can create several databases in one instance, but it's pointless.
|
|
|
|
|
I've only ever used Oracle once on a project that involved a third-party system that used it. After decades of MS SQL Server it felt like I'd gone back a decade. The interface and tools were so naff. It's like going from Visual Studio to working with java.
|
|
|
|
|
F-ES Sitecore wrote: It's like going from Visual Studio to working with java
|
|
|
|
|
Java, I think, is the big reason why Oracle is so popular. May departments in the U.S. Military uses Oracle, Oracle forms, and Java for most of their database apps and many DoD programming job descriptions require knowledge and experience with Java and Oracle.
When you are dead, you won't even know that you are dead. It's a pain only felt by others.
Same thing when you are stupid.
modified 19-Nov-21 21:01pm.
|
|
|
|
|
Sander Rossel wrote: Do people here actually like the Oracle database? Yes, I learned my first SQL statements on Oracle 7. Great product at the time, compared to alternatives like DBaseIV.
Sander Rossel wrote: I really just want to know what's so great about Oracle so I can enjoy it too (so far it's been mostly frustration). You're over 15 years too late to 'enjoy' the Oracle database-server.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: You're over 15 years too late to 'enjoy' the Oracle database-server. Thought as much
|
|
|
|
|
|
Frustration TimesTen? No thanks!
|
|
|
|
|
The type declarations - only that. Nothing else at all.
|
|
|
|
|
Sander Rossel wrote: what's so great about Oracle
What, you mean apart from having to pay a percentage of your initial purchase cost every year as a "maintenance fee"?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Oracle has a super fast optimized algorithm for one query in particular: SELECT MONEY FROM YOUR_BANK_ACCOUNT
|
|
|
|
|
Sander Rossel wrote: Do people here actually like the Oracle database?
No.
We have to support our project for both oracle and sql server, and oracle is a constant source of consternation. Like someone else said, the tools are from the stone age. And don't even get me started on on sub releases of the ODAC managed .net driver and half-assed implementation of their own database encryption with poor documentation on what features actually function.
CPallini wrote: You cannot argue with agile people so just take the extreme approach and shoot him.
:Smile:
|
|
|
|
|
I actually have a theory that PL/SQL actually stands for Polish SQL (as in Poland, the country).
First, it's like Polish, I don't understand a word of what they say.
Second, Polish are to us what Mexicans are to Americans, cheap labor (stealing our jobs)*. Larry just hired some cheap Polish people and let them make a database, hence Oracle and PL/SQL was born
*Not particularly my opinion, no offence to Polish and Mexicans
|
|
|
|
|
See also[^]
CPallini wrote: You cannot argue with agile people so just take the extreme approach and shoot him.
:Smile:
|
|
|
|
|
Don't particularly like South Park, but that's hilarious!
|
|
|
|
|
It seemed relevant lol.
CPallini wrote: You cannot argue with agile people so just take the extreme approach and shoot him.
:Smile:
|
|
|
|
|
Why do the Poles always get a bad rap, no matter what country is speaking about them? I always found that interesting.
|
|
|
|
|
Sander Rossel wrote: Do people here actually like the Oracle database? Yep
Sander Rossel wrote: Especially when compared to SQL Server. Well, both are good and have their place. One benefit with Oracle is to be able to run it on different platforms. On the other hand SQL Server admin tools are more intuitive and so on. I'd say that the differences become meaningful in environments that have special requirements.
Sander Rossel wrote: It seems everything I did so easily in SQL Server seems to be difficult or even impossible in Oracle. Any examples?
|
|
|
|