|
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?
|
|
|
|
|
Mika Wendelius wrote: One benefit with Oracle is to be able to run it on different platforms. Yes, that's one I heard and a very plausible one at that!
Good thing we run it on Windows servers
Mika Wendelius wrote: Any examples? Table variables, simply declaring some variables and using them (in all manner of ways).
For example, I simply wanted to something like the following:
DECLARE @Names TABLE (Name VARCHAR(100))
INSERT INTO @Names
SELECT Name
FROM Person.Person
SELECT @Names
SELECT Column
FROM Table
WHERE Name IN @Names
DECLARE @SomeText VARCHAR(100)
SET @SomeText = "Not doable in Oracle"
SELECT @SomeText I think the first thing with the table variable just isn't possible. My coworker, who worked with Oracle for about 30 years now, looked at me in disbelief and asked why I wanted to do such a thing anyway
The second, declaring a variable, assigning it a value and simply selecting it (FROM DUAL???) is just so awkward.
Having multiple result sets in one procedure/session isn't possible.
For example, from my software I want to insert an order, its details and do some auditing/logging and check if everything is in the database as expected.
SELECT * FROM SalesOrder
SELECT * FROM SalesOrderDetail
SELECT * FROM AuditLog I have to execute the statements one by one and check the results, no way to do it all at once and get the results next to each other.
Please, I beg of you, prove me wrong! It would make my life so much easier
Maybe I'm in a "SQL Server state of mind" and Oracle just is another paradigm? Like OOP vs. Functional? And I'm simply missing it?
|
|
|
|