|
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?
|
|
|
|
|
Hopefully people don't mind me posting a few technical stuff...
Sander Rossel wrote: I think the first thing with the table variable just isn't possible. Why? You can define a type and you can define a table for a type: PL/SQL Tables and User-Defined Records[^] Sander Rossel wrote: The second, declaring a variable, assigning it a value and simply selecting it (FROM DUAL???) is just so awkward Why not use a simple assignment
X:=5; Sander Rossel wrote: Having multiple result sets in one procedure/session isn't possible. Yes it is, and you can use REF cursors: Optimize Result Set Retrieval Using ODP.NET and Ref Cursors[^]
If these cause you headache, we can take the discussion outside, for example to Q&A. Lounge is not appropriate for these
|
|
|
|
|