The Oracle Database 12c documentation says you can set the maximum size of a
VARCHAR2 to 32,767 bytes. That’s true except when you’re trying to map a large Java string to a
VARCHAR2. It fails when the physical size of the Java string is greater than 4,000 bytes with an
ORA-01002 or fetch out of sequence error.
There’s a neat optimization in Oracle I found while tinkering around (look closely at the predicate section):
It seems strange to me:
When all needed columns are in the index, filter predicates are expectedly applied to the index
One thing that gets tedious in the IT community and Oracle community is the penchant for Windows only solutions. While Microsoft does an excellent job in certain domains, I remain a loyal Apple customer. By the way, you can install Oracle Client software on Mac OS X and run SQL Developer against any Oracle Database server.
Thanks for all your feedback on the PL/SQL Countdown quiz. I am certain we will add that to the mix soon.
And since I have decided to no longer keep all my best ideas to myself ( :-) ), I offer another idea for a "quiz", though it is not really a quiz, I suppose. More of a "game"?
I call it Code Pong (some of you may know of the classic Pong game). Here's how it would work:
In a post a couple days ago, I promised to provide a best practice approach to reading external files with the
UTL_FILE package. My first assumption is that you’re reading unstructured data because structured data is best read by external tables because external tables can read data much faster with the
Sometimes I’m surprised. Today, the surprise came when somebody pointed to an error in another author’s book. The person who asked the question had to send me a screen shot before I believed it.
The author’s code encounters the following error because the code was designed to loop through a multiple line file, and the code called the
UTL_FILE.FOPEN procedure with three instead of four parameters: