BEGIN:VCALENDAR VERSION:2.0 PRODID:-//173.231.211.74//NONSGML kigkonsult.se iCalcreator 2.26.9// CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:New York Oracle User Group X-WR-CALDESC:NYOUG X-FROM-URL:https://nyoug.org X-WR-TIMEZONE:America/New_York BEGIN:VTIMEZONE TZID:America/New_York X-LIC-LOCATION:America/New_York BEGIN:STANDARD DTSTART:20231105T020000 TZOFFSETFROM:-0400 TZOFFSETTO:-0500 RDATE:20241103T020000 TZNAME:EST END:STANDARD BEGIN:DAYLIGHT DTSTART:20240310T020000 TZOFFSETFROM:-0500 TZOFFSETTO:-0400 RDATE:20250309T020000 TZNAME:EDT END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT UID:ai1ec-2835@nyoug.org DTSTAMP:20240329T063512Z CATEGORIES: CONTACT: DESCRIPTION:Details\n\nRegister here: https://us06web.zoom.us/webinar/regis ter/6116340742130/WN_25DxOp-WTSOu98oYQSiaJA\nMost modern computer applicat ions include an “advanced search” screen that allows users to enter multip le criteria and parameters. Unfortunately\, behind the scenes\, this funct ionality can cause major implementation headaches on the back end because the resulting queries may reference an unknown number of tables and/or col umns and may return unknown numbers of rows. In addition\, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will dem onstrate how to handle generic search functionality within an Oracle datab ase by utilizing Dynamic SQL\, object collections\, and a bit of creativit y.\n—\nPresented by Michael Rosenblum\, Software Architect/Development DBA \, Dulcian\, Inc.\nMichael Rosenblum is a Software Architect/Development D BA at Dulcian\, Inc. where he is responsible for system tuning and applica tion architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQ L for Dummies (Wiley Press\, 2006)\, PL/SQL Performance Tuning Tips & Tech niques (Oracle Press\, 2014)\, contributing author of Expert PL/SQL Practi ces (APress\, 2011)\, and author of multiple database related articles and conference papers. Michael is an Oracle ACE\, a frequent presenter at var ious Oracle user group conferences (Oracle OpenWorld\, ODTUG\, IOUG Collab orate\, RMOUG\, NYOUG\, etc.)\nThis event is co-hosted by the New York Ora cle Users Group (www.nyoug.org) and Oracle Professional Services firm\, Vi scosity North America (www.viscosityna.com) DTSTART;TZID=America/New_York:20211130T120000 DTEND;TZID=America/New_York:20211130T130000 SEQUENCE:0 SUMMARY:Building Generic Search Screens Using Dynamic SQL URL:https://nyoug.org/event/building-generic-search-screens-using-dynamic-s ql/ X-COST-TYPE:free X-WP-IMAGES-URL:thumbnail\;https://nyoug.org/wp-content/uploads/2021/10/ros en_113021-300x198.jpg\;359\;237\,medium\;https://nyoug.org/wp-content/uplo ads/2021/10/rosen_113021-300x198.jpg\;359\;237\,large\;https://nyoug.org/w p-content/uploads/2021/10/rosen_113021-300x198.jpg\;359\;237\,full\;https: //nyoug.org/wp-content/uploads/2021/10/rosen_113021-300x198.jpg\;359\;237 X-ALT-DESC;FMTTYPE=text/html:\\n\\n
\\nRegister here: https://us06web.zoom.us/webinar/register/ 6116340742130/WN_25DxOp-WTSOu98oYQSiaJA
\nMost modern computer a
pplications include an “advanced search” screen that allows users to enter
multiple criteria and parameters. Unfortunately\, behind the scenes\, thi
s functionality can cause major implementation headaches on the back end b
ecause the resulting queries may reference an unknown number of tables and
/or columns and may return unknown numbers of rows. In addition\, the resu
lts may mutate depending upon the parameters. There are multiple ways of s
olving this problem with various levels of efficiency. This presentation w
ill demonstrate how to handle generic search functionality within an Oracl
e database by utilizing Dynamic SQL\, object collections\, and a bit of cr
eativity.
\n—
\nPresented by Michael Rosenblum\, Software Archit
ect/Development DBA\, Dulcian\, Inc.
Michael Rosenblum is a Softwa re Architect/Development DBA at Dulcian\, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian deve lopers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press\, 2006)\, PL/SQL Perf ormance Tuning Tips & Techniques (Oracle Press\, 2014)\, contributing auth or of Expert PL/SQL Practices (APress\, 2011)\, and author of multiple dat abase related articles and conference papers. Michael is an Oracle ACE\, a frequent presenter at various Oracle user group conferences (Oracle OpenW orld\, ODTUG\, IOUG Collaborate\, RMOUG\, NYOUG\, etc.)
\nThis event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm\, Vi scosity North America (ww w.viscosityna.com)
\n