OPP – 2007 – Session 1 – Advanced Dynamic SQL
Andrew Martinez
September 18, 2007
Business/People, Programming/Tech
No Comments
Tags: 2007, dbms_sql, dynamic, dynamic-sql, EAST, execute-immeidate, New-Jersey, OPP, Oracle, PL/SQL
The second section I attended was title “Dynamic PL/SQL.” The presentation was done by Dr. Paul Dorsey and supported by Michael Rosenblum. The topics covered were quick and rapid. However I was able to pull out a list of interesting topics covered and even some detail. The presentation was very technical and thusly was hard to write about as being done. Also the depth taken is farther than a quick blog post will do justice for.
Firstly, the quirks of dynamic SQL that were covered were the 32k length limit of a SQL query. In 8i, you could concatenate any length … Continue Reading