Loading…
View analytic
Wednesday, March 21 • 3:30pm - 4:30pm
Array of Hope

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Underused and misunderstood, PLSQL's array options are the antidote to aimless spaghetti code seen in so many PLSQL programs. In this session we'll cover the gamut, from BULK SQL operations to indexing by varchar, accomplishing what other languages would call "hash lookups" or "dictionaries." Included in the hour will be some use cases and a look at some of the errors and gotchas to be aware of. Easy and powerful.

Speakers
DS

Daniel Stober

Intermountain Healthcare
Dan Stober has been working in Oracle databases since 2001 and is an Oracle Certified SQL Expert. He is a regular presenter at local user group conferences, and has made four prior appearances at IOUG Collaborate and two invitations to Oracle OpenWorld. Frequent attendees at local events know Dan as the presenter who throws candy bars to attendees for participation in his sessions! He is a past trustee on the board of the Utah Oracle Users Group and has taught Oracle Workflow and Oracle PLSQL. Dan's published works include his article on Analytic SQL, which appeared in the Winter 2012 issue... Read More →



Wednesday March 21, 2018 3:30pm - 4:30pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112