Somebody said, I shouldn’t have buried so much information in an answer to a question posed in a comment on a summary blog page. Especially, since it’s obviously a not real contact information. They suggested I put it in a regular blog post, and here it is with as little editing as possible.
The Ron Quizon user provided this sample code and a “What’s wrong with this PL/SQL program?”
That the consulate in Benghazi could have been breached and four Americans, including the Ambassador killed, shows that there were mistakes made. The Obama Administration should investigate, report its results, and then perhaps it might make sense for the Senate to evaluate that report and decide if it should investigate, all on its own.
Instead, Republican Senators have apparently decided that they can make a gigantic mountain of what is likely a molehill: Ambassador to the UN Susan Rice's comments on TV soon after the attack took place.
The renowned Oracle ACE, Asif Momen deserves full credit in producing a quality work on Oracle database overview and awareness of related terms. The style of the Packt’s book “Oracle Database XE 11gR2 Jump Start Guide” is a perfect KISS (Keep It Short and Simple). Best aspect being that the book successfully drives its objectives and … Continue reading →
It is, when you think about, a lot like playing god. You get to create your own world and invite people to inhabit it.
But creating (and maintaining) worlds can be really difficult.
For example, this weekend we upgraded to APEX version 4.2.
And after we were done with the upgrade, which occurred without any complications and resulted in successful upgrades for many of the applications running in this APEX instance, we found that the PL/SQL Challenge webpages had become, how shall I put this, blank.
One of the students wanted an equivalent example to an Oracle DML trigger sample that replaces a white space in a last name with a dash for an INSERT statement. Apparently, the MySQL trigger example in the Oracle Database 11g and MySQL 5.6 Developer Handbook was a bit long. I have to agree with that because the MySQL DML trigger demonstrated cursors and loops in the trigger code.
Two things contributed to this post. One was a student question about the difference between the MAX_VALUE of a sequence and the actual sequence value. The other was a comment on an earlier post addressing an NDS approach to resetting sequences.
The student wanted to understand why there were gaps in the sequence, since they created it with the default values, like this: