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.
15 thoughts on “Common Mistakes in Oracle PL/SQL Programming”
Leave a Reply
You must be logged in to post a comment.
check this.learn report program generator
as400 – rpg . tk
Thank you for your kind video ; so useful!
This is fantastic Video..For PL/SQL developer..Steven is genious..Fantastics ex for BULK COLLCETS ,COLLECTION etc..
It’s really helpful video to the traditional PL/SQL programmers.,
Raja
useful
Mucahid Uslu
Coming from using sql*plus in cost systems professionally until 1994, then vanishing into mechanical engineering until right now, this is almost understandable.
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.
we compressed the file and are directors.
how did you get to upload a 62 min video?
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.
We are directors. You will need to become a director on YouTube.
Bad audio quality :/ Could be better i think.
Oh no, you didn’t.
lol
no, i didn’t