view counter
Home

PL/SQL Feed

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

Changing value of iterator in FOR loop: Yes, you can! (2023)

In the 16 February quiz, we asked: "Which of the following statements about the iterator (also referred to as the index) of a FOR loop are correct?" And we scored this choice as incorrect: "You can change the value of the iterator, but the new value must fall within the low and high values specified in the FOR loop header."

The explanation given was as follows:

Any attempt to change the value of the iterator will cause the following compilation error to be raised:

Feb 19, 2011 9:02am

Autonomous Transactions and Deadlocks (2024)

A player wrote in response to the 17 February quiz:

Feb 19, 2011 8:18am

Why SELECT-INTO, eh?

Somebody raised the question about writing stored functions while we were discussing scalar subqueries against COMMON_LOOKUP tables. Common look up tables store collections of possible <OPTION> elements. They’re basically generalized tables that contain a set of smaller tables, where the row sets make up a list of unique values. When you write a function that [...]

Feb 16, 2011 9:03pm

Query MySQL in Excel 2007

The original blog post with the images was causing a page loading delay, so I’ve moved it to a page of it’s own. This link send you to the original post with how you setup MySQL Connector/ODBC driver, add a new data source in Windows 7, and a new data import source in Excel 2007. [...]

Feb 14, 2011 11:25pm

SQL challenge #2

Here is a solution to Iggy Fernandez The Second SQL challenge: WITH T(W2,OUT) AS ( SELECT WORD2, WORD1 || ' ' || WORD2 || ' ' || WORD3 FROM RIDDLE UNION ALL SELECT R.WORD2, T1.out || ' ' || R.WORD2 || ' ' || T2.out FROM T T1, RIDDLE R, T T2 WHERE T1.W2 = [...]

Feb 14, 2011 1:21pm

Trace an Oracle application client user in 3-tier environment

Let us suppose that you want to trace client user which was established in an application environment( for example  Oracle  E-Business-Suite application  in 3-tier  architecture) Tracing  a  client Let’s suppose there are two client or application user (JOEL and LASZLO). They use the same application, but different modules and doing different activities. Via connection pool [...]

Feb 10, 2011 6:23am

Trace an arbitrary Oracle application session in client/server architecture

Let us suppose that you want to trace a session which was established in client/server architecture (Dedicated Server architecture) Tracing  a  session This method is applicable, if the session was created by an c/s application. Very easy to identify which is the target  session: Let us suppose that  the session is identified by SID=420 and [...]

Feb 10, 2011 3:01am

Tracing your Oracle session

How to trace Oracle session using SQL and PL/SQL tools? Many times developers and/or DBA’s want to trace their own and/or other session’s  SQL and PL/SQL activities. There are many possibilities to solve this problem especially, if you  want to trace your  session. Very easy to identify which is your session:    Let us suppose [...]

Feb 10, 2011 1:20am

Excel 2001 Needs ODBC Files

I’d hoped for a better solution with Excel 2011 on Mac OS X but it appears we still need the third party drivers to connect Excel to MySQL. It’s the same as I reported earlier on Excel 2008. Here’s the message and you can click on it to go the web site and links to [...]

Feb 10, 2011 1:15am

Mac OS X MySQL Install

Installing MySQL 5.5.9 on Mac OS X was on my list but it finally made the top. I needed to write instructions for a class that I teach because asking students who own a Mac to install VMWare and Windows before MySQL seems an unnecessary burden. Especially when you can install it directly on Mac [...]

Feb 10, 2011 12:57am
view counter