Spoems - Common Mistakes in Oracle PL/SQL Programming

Common Mistakes in Oracle PL/SQL Programming

Back


You did WHAT? You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? If slip-ups like these sound familiar (or if you don't know why these are mistakes), join Quest for a one-hour Webcast featuring guest speaker, Steven Feuerstein, as he examines common mistakes in Oracle PL/SQL programming. Learn how to correct mistakes to improve the maintainability and performance of your application. This Webcast will also demonstrate CodeXpert — a powerful feature available within Toad® that will help you avoid common mistakes and ensure you implement PL/SQL best practices in your daily activities. About the Guest Speaker: Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written nine published books on PL/SQL (all from O'Reilly & Associates). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as a Senior Technology Advisor to Quest Software.

Channel: Entertainment
Uploaded: March 6, 2007 at 4:59 pm
Author: questsoftware

Length: 1:02:47
Rating: 4.68
Views: 46,457

Tags: Oracle PLSQL Programming Steven Feuerstein Quest Software Toad best practices

Video Thumbnail #1:




Video Thumbnail #2:




Video Thumbnail #3:




Video Url:


Embed Code:


Video Comments:
sandip1969 (Tuesday 2nd of September 2008 08:22:55 AM)
This is fantastic Video..For PL/SQL developer..Steven is genious..Fantastics ex for BULK COLLCETS ,COLLECTION etc..
konankir (Thursday 3rd of April 2008 01:49:13 PM)
It's really helpful video to the traditional PL/SQL programmers., Raja
mucuslu (Monday 7th of January 2008 09:23:01 AM)
useful Mucahid Uslu
corrdude (Wednesday 14th of November 2007 08:46:38 PM)
Coming from using sql*plus in cost systems professionally until 1994, then vanishing into mechanical engineering until right now, this is almost understandable.
kwik13a (Monday 5th of November 2007 12:02:15 AM)
how did you get to upload a 62 min video?
questsoftware (Monday 5th of November 2007 05:27:35 AM)
we compressed the file and are directors.
asdasdas456 (Monday 27th of October 2008 01:13:20 PM)
Thank you for your kind video ; so useful!
gli7utubeo (Thursday 4th of October 2007 10:10:17 PM)
PL/SQL is great and completely under-used. SQL by itself is a nightmare. Why would anyone want to write the entire logic of a program in a single sentence? Complicated SQL statments are nearly impossible to write, read, modify, or debug. A bit of logic written programmatically in PL/SQL (or equivalent procedural language) is clear and simple.
pbm6666 (Wednesday 7th of November 2007 08:06:03 PM)
If you don't care anything about performace then sure put your data logic in PL/SQL. While you code is still chunking along my pure sql statements will be long over and done with. Go read Ask Tom on this topic before giving the world horrible advice.
questsoftware (Thursday 26th of July 2007 06:49:04 AM)
We are directors. You will need to become a director on YouTube.