Tag Archives: pl/sql

PL/SQL New Features in Oracle Database 12c

I recently put some more PL/SQL new features articles live. PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1) Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1) Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1) I’ve also posted a top-level new features […]

The Future of PL/SQL : The People Respond

I put out a post yesterday called The Future of PL/SQL : My Opinion. For an Oracle-related blog, putting something out at the weekend is a sure fire way to get nobody reading it. If I look at my website, the hit rate at the weekend is about 1/5 of that of a week day. By the […]

The Future of PL/SQL : My Opinion

Although a lot of my effort at the moment is focused on DBA features, I have written some articles on PL/SQL enhancements. There are a few neat new features for PL/SQL developers in 12c, but you could be forgiven for thinking it is a little underwhelming. There are two ways to look at this: OMG. Oracle really don’t […]

PL/SQL White Lists in Oracle Database 12c Release 1 (12.1)

I’ve been playing about with the ACCESSIBLE BY clause to create PL/SQL white lists in Oracle 12c. Here’s the article I wrote about it. PL/SQL White Lists Using the ACCESSIBLE BY Clause in Oracle Database 12c Release 1 (12.1) There seem to be some discrepancies in the documentation*, which I’ve highlighted in the article. Not […]

WITH Clause Enhancements in Oracle 12c…

After doing a number of 12c installations, I decided it was time to write something new. I figured I’d pick something easy to start off with, so here is the first thing off the press. WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) Over the last year I’ve heard a few speakers talk […]

Why is it easier to get things to work at home?

I’ve been grabbing a few minutes here and there over the last couple of work days trying to get something working with no joy. I this case it is a DAD entry in the “dads.conf” file on the OHS running as part of 11gR2 Forms & Reports Services on WebLogic 11g (10.3.6). I started to […]

HTML with Embedded Images from PL/SQL…

Someone asked me a question about generating HTML with embedded images from PL/SQL and my answer started to spiral out of control, so I figured I’d just write it as an article. HTML with Embedded Images from PL/SQL Cheers Tim…

Advert: PL/SQL Masterclass Updates…

This month I’ll be doing some PL/SQL Masterclasses for Oracle University. The following dates have been confirmed: Singapore (14-15) Syndey (18-19) Melbourne (21-22) For more details contact Oracle University here. Originally there was an extra session in Hong Kong, but this has now been cancelled. In November the following dates are scheduled: Bulgaria (22-23) Serbia […]

Advert: Asia Pacific PL/SQL Masterclasses…

It’s a little over a month before I start a run of four PL/SQL Masterclasses in the Asia Pacific region. Singapore (14-15 October) Syndey (18-19 October) Melbourne (21-22 October) Hong Kong (25-26 October) If you are interested, contact Oracle and get booked on. The details are here: APAC Seminars. Cheers Tim…

Oracle Database 11g: Advanced PL/SQL (1Z0-146)…

Lewis Cunningham recently mentioned on twitter that he had taken this exam and it reminded me I had been meaning to take it ever since it was announced in beta, but never actually got round to it. A quick search of my blog revealed it’s nearly 2 years since I mentioned I wanted to sit […]