tag:blogger.com,1999:blog-8677649049588007585.post7009027935578994450..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Wanted: Your Ideas for Key PL/SQL EnhancementsSteven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8677649049588007585.post-70838241778222879342011-11-03T15:32:10.415+00:002011-11-03T15:32:10.415+00:00Another issue that would be very useful is having ...Another issue that would be very useful is having the possibility to specify the starting row when using BULK COLLECT INTO (without the need to use "Row_Number() OVER ()" or primary-key-filtering to do it manually).<br /><br />This would especially be very useful for web-programming, for example if you want to display a maximum of 50 records starting from row 1001 in a table you should be able to easily say:<br /><br />SELECT fields,...<br />BULK COLLECT INTO tblData<br />STARTING AT 1001 LIMIT 50;<br /><br />Greetings, NielsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-72143222801121140292011-11-02T18:54:05.041+00:002011-11-02T18:54:05.041+00:00Hello Steven, All,
Just to continue what Niels al...Hello Steven, All,<br /><br />Just to continue what Niels already has written above, a natural request that I have already seen in other places as well is to add access in the DML triggers to :OLD.ROW and :NEW.ROW record variables defined implicitly as having type MyTable%ROWTYPE, thus allowing them to be passed as one single actual parameter to other subprograms.<br /><br />Once the "SET ROW = ..." update syntax and the INSERT of entire records became supported,<br />adding the :OLD.ROW and :NEW.ROW records is just the natural counterpart of these.<br /><br />Thanks & Best Regards,<br />Iudith MentzelAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-72642530025828030502011-11-02T10:10:52.140+00:002011-11-02T10:10:52.140+00:00Hello Steven,
I have already submittet a few topi...Hello Steven,<br /><br />I have already submittet a few topics to your ILovePLSQLAnd.net site.<br /><br />In my eyes the most important topics are:<br /><br />- BULK COLLECT non-sequentially into collections<br />- Get COUNT of elements in subset of collection<br /><br />- Show package's subprogram name in call stack and backtrace (which shouldn't be so difficult if PLSCOPE_SETTINGS is set to "IDENTIFIERS:ALL")<br /><br />And nice to have would be:<br />- Improve SAVE EXCEPTIONS in FORALL<br />- Pass exceptions as arguments<br />- Support definition of private attributes and methods in Object Types<br />- Better Access to New/Old Data In Triggers<br /><br />Greetings, NielsAnonymousnoreply@blogger.com