Oracle PL/SQL Programming
This links to my blog posts and pages dealing with PL/SQL programming. They include PL/SQL programming solution architectures, examples, techniques, and structures. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.
PL/SQL architecture ↓
A list of blog posts and pages dealing with Oracle PL/SQL architecture.
Learn about Oracle Database 11g New PL/SQL Features
Learn how to guarantee an external file before querying it.
Learn how to manage transaction control for external binary files in an Oracle Database.
Learn how to manage transaction control when deleting an external file.
Learn how to use an Adapter Object-Oriented design pattern in PL/SQL.
Learn how reference cursors really work – the why, when, and how.
PL/SQL examples ↓
A list of blog posts and pages with PL/SQL programming examples.
Learn about how PL/SQL formal parameter modes really work.
Learn about how you write a dynamic cursor and dynamic NDS cursor.
Learn about how you use a dynamic PL/SQL reference cursor, and how you don’t use it.
Learn how you implement an optional foreign key trigger.
Learn how you insert a colon in an NDS statement without treating like a bind variable.
Learn how you use the FOR UPDATE works with the WHERE CURRENT OF statement.
PL/SQL structures ↓
A list of blog posts and pages covering example of the Oracle PL/SQL language structures.
PL/SQL techniques ↓
A list of blog posts and pages showing techniques with Oracle PL/SQL.
If you have ideas of things that should be here that aren’t, leave a comment on the blog. In case you’re looking for my PL/SQL books, here are a couple links: Oracle Database 11g PL/SQL Programming
Subscribe via RSS
Swapnil, Have you checked
NUMTODSINTERVALorNUMTOYMINTERVAL? These are variations of the string conversionTO_DSINTERVALandTO_YMINTERVAL. The only difference is that the actual parameter being a number versus a string. I actually covered theTO_DSINTERVALandTO_YMINTERVALfunctions in the new Oracle Database 12c PL/SQL Programing book.maclochlainn
9 Apr 14 at 10:31 am
Thanks, will look for same…
swapnil
11 Apr 14 at 4:27 am
Hi,your blog really helpful for me to gothrough the basic concepts..thanks!!
vani
4 Jul 14 at 4:18 am
Hi Mac,
Its been long time not taken any valuable suggestion from you 🙂
I had a task to tune PL/SQL package .
Can you please suggets the steps to achive same?
One thing i know is about
DBMS_PROFILER.Apart from this is there any way to achieve same?
Db:Oracle 8i
Apppreciate your efforts….
Thanks
Swapnil
21 Jul 14 at 7:04 am
Hello, I am trying to work through your book ‘Oracle Database 12c PL/SQL Programming’ and I have downloaded the oracle12cplsqlcode.zip.
The files for ‘Introduction’ appear to be somewhat out of date for 12c and the scripts have typos and no general instructions on use.
A little cleanup, etc. could help novices such as me.
Thanks.
Charles
21 May 15 at 1:53 pm
Charles, I don’t know which version you have but here’s the 12cPLSQLCode file that I use in class. If you find any errors, drop me a note and I’ll fix it.
After you unzip the file, navigate to the Introduction folder and run the
create_oracle_store.sqlscript. That script calls all the other scripts.This is what you see in the Introduction folder:
Thanks,
Michael
maclochlainn
21 May 15 at 9:04 pm