... forgot at least on important thing after reading another Oracle WTF.
Empty Strings ('') = NULL
I can't count the number of occassions where this "special feature" in
Oracle caused me and others to figure out a workaround. Thanks Larry ...
l.
lofwyr
@lofwyr
Best posts made by lofwyr
-
RE: Why the I-Hate-Oracle Club?
Latest posts made by lofwyr
-
RE: Possibly stupid question
@Mcoder said:
@skotl said:
And, much as I hate Oracle (the company and the products), I still maintain that if you want a multi-active-node, HA, load-balanced, sure-you-can-have-a-lazy-write-instance-for-reporting RDBMS solution, then Oracle RAC is it.
Funny thing that the one time when I was at a place that was looking into that kind of thing, when we showed our requisites to a vendor the replay was "no, you can't do that with Oracle, in fact you can't do that with any [relational] database". That, and a following discussion about the meaning of the word "active".
Later that same day I tryed researching it, and yep, Postgres could do all that. But that was by 2007, maybe Oracle did improve by now.
Oracle RAC was introduced with version 9i around 2001. I'm not aware that postgres allows for a "shared everything" cluster architecture. Maybe your requisites required some other features?
l.
-
RE: Possibly stupid question
My reasons for using Oracle DBMS vs mysql or postgres:
- PL/SQL
- RMAN (how do you teach postgres compressed, incremental online backup, just out of curiosity?)
- Application Express (APEX)
- Partitioning (Enterprise Edition Feature (swapping tables with partitions, compression, etc.), postgres uses triggers AFAIK)
- Table Compression (SE1 and above)
- statspack (or awr), tkprof
l.
-
RE: Help with Oracle Analytic Functions
Some test data (a few records per table) and the expected result would've been nice.
l.
-
RE: Oracle vs. Postgres, the choice is obvious
@roto said:
That is very clever, but I'm sure I'm no competition for you. You still didn't tell me what would have been nice about me not mouthing off.
I wrote: It would have been nice if you'd read up some things in the user documentation [b]before[/b] mouthing off.
Seems to me your reading disability is not limited to user documentation, but since you asked me to show your inability.
l.
-
RE: Oracle vs. Postgres, the choice is obvious
@roto said:
I'm sorry, did my mouthing off offend you? What would have been "nice" about it?
Me? No. It's always good to know if competition (you) is not able to read user documentation. Gives others, like me, an edge.
l.
-
RE: Oracle vs. Postgres, the choice is obvious
@seraphim said:
"Unlimited" text field per table? Don't follow you. The CLOB datatype allows text of up to 4 gigabytes per column, and you can certainly have more than one CLOB in a table. Could you give an example of the problem you're hitting?
On 10g2 the size of a CLOB can range between 8 and 128TB
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/datatypes.htm#i43142
To the OP: It would have been nice if you'd read up some things in the user documentation before mouthing off, such as the text column argument.
l.
-
RE: Even Oracle hates Oracle
@growse said:
Don't you see? 11g is mysql!!!!!!
(just with a different name, and the elimination of the empty string :-))
Ah, now I see the bigger picture. Why, thank you ... ;-)
l.
-
RE: Even Oracle hates Oracle
I wonder how the development of 11g fits into that picture.
l.
-
RE: Best. Error. Message. Ever.
From the documentation:
SQL*Loader-00926: OCI error while string for table string
-
Cause: An OCI error has occurred.
-
Action: Check the message below this one in the log file for more information. The table or column referenced may not be accessible.
You did read the documentation, right?
l.
-