view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Upsert method 1: When you expect to be mostly adding data


Click the image for copy-pastable script to see this in action

SELECT-INTO variables

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?”

The Oracle equivalent of SHIFT+DELETE


Click the image for example scripts

Benghazi vs. Iraq: When do GOP Senators Get Riled Up?

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.

Book Review: Oracle Database XE 11gR2 Jump Start Guide by Asif Momen

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).

Tired of large inserts failing due to one row? Try this:


Click the image for scripts to show this in action

Upgraded to APEX 4.2 and....Goodbye Website!

Software is a funny thing.

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.

MySQL Database Triggers

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.

view counter