Oracle Database 11g Advanced PLSQL

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle certified instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner.Oracle11g: Advanced PL/SQL

Introduction to PL/SQL

PL/SQL Programming Concepts: Review

List restrictions on calling functions from SQL expressions
Hand exceptions
Manage dependencies
Use Oracle-supplied packages

Designing PL/SQL Code

Identify guidelines for cursor design
Use cursor variables
Create subtypes based on existing types

Working with Collections

Create collections (nested table, array and associative arrays, PL SQL tables)
Use collections methods
Manipulate collections
Distinguish between the different types of collections and their uses

Using Advanced Interface Methods

Execute external C programs from PL/SQL
Execute Java programs from PL/SQL

Implementing Fine-Grained Access Control for VPD

Explain the process of fine-grained access control
Implement and test fine-grained access control

Manipulating Large Objects

Create and manage LOB data types
Use the DBMS_LOB PL/SQL package
Use of temporary LOBs

Administering SecureFile LOBs

Describe SecureFile LOB features
Enable SecureFile LOB deduplication, compression, and encryption
Migrate BasicFile LOBs to the SecureFile LOB format

Performance and Tuning

Use native and interpreted compilation methods
Tune PL/SQL code
Enable intraunit inlining

Improving Performance with Caching

Improve memory usage by caching SQL result sets and using the DBMS_RESULT_CACHE package
Write queries that use the result cache hint
Set up PL/SQL functions to use PL/SQL result caching

Analyzing PL/SQL Code

Run reports on source code
Determine identifier types and usages
Use DBMS_METADATA to retrieve object definitions

Profiling and Tracing PL/SQL Code

Trace PL/SQL program execution
Profile PL/SQL applications

Safeguarding Your Code Against SQL Injection Attacks

Describe SQL injections
Reduce attack surfaces
Use DBMS_ASSERT
Design immune code
Test code for SQL injection flaws

Flexible Class Options

Morning | Evening Classes | Workshops | Fast-Track
Week End Classes For Professionals SAT | SUN
Online Classes – Live Virtual Class (L.V.C), Online Training

Find Oracle DBA Jobs and Salaries (click on URL)

Oracle Job Interview Preparation

Oracle ERP Implantation & Support Services

Need Oracle ERP E-Business Suite | Fusion Cloud Implementation Services
Need Oracle ERP Healthcheck or Database Support Services

Job Interview Preparation (Soft Skills Questions & Answers)

🎥 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

Flexible Class Options

Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training

Recommended Courses (Advanced Certification Tracks)

Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Database 11g SQL Fundamentals
Oracle Database 11g Advanced PLSQL

Oracle BI 11g : OBIEE – Build Repository
Oracle BI 11g : OBIEE – Create Analyses and Dashboards
Oracle Forms Developer Course – Build Internet Applications

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

AMAZING Discount OFFER

Weekend Classes for Professionals

Internship Opportunity

*Installment Fee Payment available for deserving students

Inquire Now

JTIwJTIwJTNDaHRtbWwlM0UlMEElM0Nib2R5JTNFJTBBJTNDJTIxLS0lMjBOb3RlJTIwJTNBJTBBJTIwJTIwJTIwLSUyMFlvdSUyMGNhbiUyMG1vZGlmeSUyMHRoZSUyMGZvbnQlMjBzdHlsZSUyMGFuZCUyMGZvcm0lMjBzdHlsZSUyMHRvJTIwc3VpdCUyMHlvdXIlMjB3ZWJzaXRlLiUyMCUwQSUyMCUyMCUyMC0lMjBDb2RlJTIwbGluZXMlMjB3aXRoJTIwY29tbWVudHMlMjAlRTIlODAlOUNEbyUyMG5vdCUyMHJlbW92ZSUyMHRoaXMlMjBjb2RlJUUyJTgwJTlEJTIwJTIwYXJlJTIwcmVxdWlyZWQlMjBmb3IlMjB0aGUlMjBmb3JtJTIwdG8lMjB3b3JrJTIwcHJvcGVybHklMkMlMjBtYWtlJTIwc3VyZSUyMHRoYXQlMjB5b3UlMjBkbyUyMG5vdCUyMHJlbW92ZSUyMHRoZXNlJTIwbGluZXMlMjBvZiUyMGNvZGUuJTIwJTBBJTIwJTIwJTIwLSUyMFRoZSUyME1hbmRhdG9yeSUyMGNoZWNrJTIwc2NyaXB0JTIwY2FuJTIwbW9kaWZpZWQlMjBhcyUyMHRvJTIwc3VpdCUyMHlvdXIlMjBidXNpbmVzcyUyMG5lZWRzLiUyMCUwQSUyMCUyMCUyMC0lMjBJdCUyMGlzJTIwaW1wb3J0YW50JTIwdGhhdCUyMHlvdSUyMHRlc3QlMjB0aGUlMjBtb2RpZmllZCUyMGZvcm0lMjBiZWZvcmUlMjBnb2luZyUyMGxpdmUuLS0lM0UlMEElM0NkaXYlMjBpZCUzRCUyN2NybVdlYlRvRW50aXR5Rm9ybSUyNyUyMHN0eWxlJTNEJTI3d2lkdGglM0E2MDBweCUzQm1hcmdpbiUzQWF1dG8lM0IlMjclM0UlMEElMjAlMjAlMjAlM0NNRVRBJTIwSFRUUC1FUVVJViUyMCUzRCUyN2NvbnRlbnQtdHlwZSUyNyUyMENPTlRFTlQlM0QlMjd0ZXh0JTJGaHRtbCUzQmNoYXJzZXQlM0RVVEYtOCUyNyUzRSUwQSUyMCUyMCUyMCUzQ2Zvcm0lMjBhY3Rpb24lM0QlMjdodHRwcyUzQSUyRiUyRmNybS56b2hvLmNvbSUyRmNybSUyRldlYlRvTGVhZEZvcm0lMjclMjBuYW1lJTNEV2ViVG9MZWFkczg3NTc0MDAwMDAwMDI2NzAwNSUyMG1ldGhvZCUzRCUyN1BPU1QlMjclMjBvblN1Ym1pdCUzRCUyN2phdmFzY3JpcHQlM0Fkb2N1bWVudC5jaGFyc2V0JTNEJTIyVVRGLTglMjIlM0IlMjByZXR1cm4lMjBjaGVja01hbmRhdG9yeSUyOCUyOSUyNyUyMGFjY2VwdC1jaGFyc2V0JTNEJTI3VVRGLTglMjclM0UlMEElMEElMDklMjAlM0MlMjEtLSUyMERvJTIwbm90JTIwcmVtb3ZlJTIwdGhpcyUyMGNvZGUuJTIwLS0lM0UlMEElMDklM0NpbnB1dCUyMHR5cGUlM0QlMjd0ZXh0JTI3JTIwc3R5bGUlM0QlMjdkaXNwbGF5JTNBbm9uZSUzQiUyNyUyMG5hbWUlM0QlMjd4blFzanNkcCUyNyUyMHZhbHVlJTNEJTI3MzVjYTZhNDZlYjEzNGRjYjM4NjllMzBlZjY5YjFlODFkN2EyZjFmZTRkMTU1N2Q4ZjdhYjkwM2Q3ZDdiOTA1OCUyNyUyRiUzRSUwQSUwOSUzQ2lucHV0JTIwdHlwZSUzRCUyN2hpZGRlbiUyNyUyMG5hbWUlM0QlMjd6Y19nYWQlMjclMjBpZCUzRCUyN3pjX2dhZCUyNyUyMHZhbHVlJTNEJTI3JTI3JTJGJTNFJTBBJTA5JTNDaW5wdXQlMjB0eXBlJTNEJTI3dGV4dCUyNyUyMHN0eWxlJTNEJTI3ZGlzcGxheSUzQW5vbmUlM0IlMjclMjBuYW1lJTNEJTI3eG1Jd3RMRCUyNyUyMHZhbHVlJTNEJTI3NmMyODU2NGU5YTU3MjhhYjRjNjViY2YxZDRjMGU1YTBmNTM1ZjkwZDZkNTZlYzliNjIxZGYyYzBkNTIyNTRmYSUyNyUyRiUzRSUwQSUwOSUzQ2lucHV0JTIwdHlwZSUzRCUyN3RleHQlMjclMjBzdHlsZSUzRCUyN2Rpc3BsYXklM0Fub25lJTNCJTI3JTIwJTIwbmFtZSUzRCUyN2FjdGlvblR5cGUlMjclMjB2YWx1ZSUzRCUyN1RHVmhaSE0lM0QlMjclMkYlM0UlMEElMEElMDklM0NpbnB1dCUyMGlkJTNEJTI3cmV0dXJuVVJMJTI3JTIwdHlwZSUzRCUyN3RleHQlMjclMjBzdHlsZSUzRCUyN2Rpc3BsYXklM0Fub25lJTNCJTI3JTIwbmFtZSUzRCUyN3JldHVyblVSTCUyNyUyMCUyRiUzRSUyMCUwQSUwOSUyMCUzQyUyMS0tJTIwRG8lMjBub3QlMjByZW1vdmUlMjB0aGlzJTIwY29kZS4lMjAtLSUzRSUwQSUwOSUzQ3N0eWxlJTNFJTBBJTA5JTA5dHIlMjAlMkMlMjB0ZCUyMCU3QiUyMCUwQSUwOSUwOSUwOXBhZGRpbmclM0ExMHB4JTNCJTBBJTA5JTA5JTA5Ym9yZGVyLXNwYWNpbmclM0EwcHglM0IlMEElMDklMDklMDlib3JkZXItd2lkdGglM0EwcHglM0IlMEElMDklMDklMDloZWlnaHQlM0ExMDAlMjUlMEElMDklMDklMDlib3JkZXItYm90dG9tJTNBJTIwMXB4JTIwc29saWQlMjBibHVlJTNCJTBBJTA5JTA5JTA5JTdEJTBBJTA5JTNDJTJGc3R5bGUlM0UlMEElMDklM0N0YWJsZSUyMGNsYXNzJTNEJTIyY29udGFjdGZvcm0lMjIlM0UlMEElMEElMDklM0N0ciUzRSUzQ3RkJTIwY29sc3BhbiUzRCUyNzIlMjclMjBjbGFzcyUzRCUyMmNyb3doJTIyJTNFJTNDc3Ryb25nJTNFSW5xdWlyeSUzQyUyRnN0cm9uZyUzRSUzQyUyRnRkJTNFJTNDJTJGdHIlM0UlMEElMEElMDklM0N0ciUzRSUzQ3RkJTIwY2xhc3MlM0QlMjJjcm93JTIyJTNFRmlyc3QlMjBOYW1lJTNDJTJGdGQlM0UlM0N0ZCUyMGNsYXNzJTNEJTIyY3JvdzElMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUzRSUzQ2lucHV0JTIwdHlwZSUzRCUyN3RleHQlMjclMjBjbGFzcyUzRCUyMmNvbmlucHV0JTIyJTIwc3R5bGUlM0QlMjclMjclMjAlMjBtYXhsZW5ndGglM0QlMjc0MCUyNyUyMG5hbWUlM0QlMjdGaXJzdCUyME5hbWUlMjclMjAlMkYlM0UlM0MlMkZ0ZCUzRSUzQyUyRnRyJTNFJTBBJTBBJTA5JTNDdHIlM0UlM0N0ZCUyMCUyMGNsYXNzJTNEJTIyY3JvdyUyMiUzRUxhc3QlMjBOYW1lJTNDc3BhbiUyMHN0eWxlJTNEJTI3Y29sb3IlM0FyZWQlM0IlMjclM0UlMkElM0MlMkZzcGFuJTNFJTNDJTJGdGQlM0UlM0N0ZCUyMGNsYXNzJTNEJTIyY3JvdzElMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUzRSUzQ2lucHV0JTIwdHlwZSUzRCUyN3RleHQlMjclMjBjbGFzcyUzRCUyMmNvbmlucHV0JTIyJTIwc3R5bGUlM0QlMjclMjclMjAlMjBtYXhsZW5ndGglM0QlMjc4MCUyNyUyMG5hbWUlM0QlMjdMYXN0JTIwTmFtZSUyNyUyMCUyRiUzRSUzQyUyRnRkJTNFJTNDJTJGdHIlM0UlMEElMEElMDklM0N0ciUzRSUzQ3RkJTIwJTIwY2xhc3MlM0QlMjJjcm93JTIyJTNFRW1haWwlM0NzcGFuJTIwc3R5bGUlM0QlMjdjb2xvciUzQXJlZCUzQiUyNyUzRSUyQSUzQyUyRnNwYW4lM0UlM0MlMkZ0ZCUzRSUzQ3RkJTIwY2xhc3MlM0QlMjJjcm93MSUyMiUyMHN0eWxlJTNEJTI3JTI3JTIwJTNFJTNDaW5wdXQlMjB0eXBlJTNEJTI3dGV4dCUyNyUyMGNsYXNzJTNEJTIyY29uaW5wdXQlMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUyMG1heGxlbmd0aCUzRCUyNzEwMCUyNyUyMG5hbWUlM0QlMjdFbWFpbCUyNyUyMCUyRiUzRSUzQyUyRnRkJTNFJTNDJTJGdHIlM0UlMEElMEElMDklM0N0ciUzRSUzQ3RkJTIwJTIwY2xhc3MlM0QlMjJjcm93JTIyJTNFQ29tcGFueSUzQyUyRnRkJTNFJTNDdGQlMjBjbGFzcyUzRCUyMmNyb3cxJTIyJTIwc3R5bGUlM0QlMjclMjclMjAlM0UlM0NpbnB1dCUyMHR5cGUlM0QlMjd0ZXh0JTI3JTIwY2xhc3MlM0QlMjJjb25pbnB1dCUyMiUyMHN0eWxlJTNEJTI3JTI3JTIwJTIwbWF4bGVuZ3RoJTNEJTI3MTAwJTI3JTIwbmFtZSUzRCUyN0NvbXBhbnklMjclMjAlMkYlM0UlM0MlMkZ0ZCUzRSUzQyUyRnRyJTNFJTBBJTBBJTA5JTNDdHIlM0UlM0N0ZCUyMCUyMGNsYXNzJTNEJTIyY3JvdyUyMiUzRVBob25lJTNDc3BhbiUyMHN0eWxlJTNEJTI3Y29sb3IlM0FyZWQlM0IlMjclM0UlMkElM0MlMkZzcGFuJTNFJTNDJTJGdGQlM0UlM0N0ZCUyMGNsYXNzJTNEJTIyY3JvdzElMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUzRSUzQ2lucHV0JTIwdHlwZSUzRCUyN3RleHQlMjclMjBjbGFzcyUzRCUyMmNvbmlucHV0JTIyJTIwc3R5bGUlM0QlMjclMjclMjAlMjBtYXhsZW5ndGglM0QlMjczMCUyNyUyMG5hbWUlM0QlMjdQaG9uZSUyNyUyMCUyRiUzRSUzQyUyRnRkJTNFJTNDJTJGdHIlM0UlMEElMEElMDklM0N0ciUyMCUzRSUzQ3RkJTIwJTIwY2xhc3MlM0QlMjJjcm93JTIyJTNFQ29tbWVudHMlMjAlM0MlMkZ0ZCUzRSUzQ3RkJTIwY2xhc3MlM0QlMjJjcm93MSUyMiUzRSUyMCUzQ3RleHRhcmVhJTIwJTIwbmFtZSUzRCUyN0xFQURDRjElMjclMjBtYXhsZW5ndGglM0QlMjcyMDAwJTI3JTIwY2xhc3MlM0QlMjJjb25pbnB1dCUyMiUyMHN0eWxlJTNEJTI3JTI3JTNFJTI2bmJzcCUzQiUzQyUyRnRleHRhcmVhJTNFJTNDJTJGdGQlM0UlM0MlMkZ0ciUzRSUwQSUzQ3RyJTIwaGlkZGVuJTNFJTNDdGQlMjAlMjBjbGFzcyUzRCUyMmNyb3clMjIlM0VQYWdlJTIwVVJMJTNDJTJGdGQlM0UlM0N0ZCUyMGNsYXNzJTNEJTIyY3JvdzElMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUzRSUzQ2lucHV0JTIwaWQlM0QlMjd1cmwlMjclMjB0eXBlJTNEJTI3dGV4dCUyNyUyMGNsYXNzJTNEJTIyY29uaW5wdXQlMjIlMjBzdHlsZSUzRCUyNyUyNyUyMCUyMG1heGxlbmd0aCUzRCUyNzI1NSUyNyUyMG5hbWUlM0QlMjdMRUFEQ0Y4JTI3JTIwJTJGJTNFJTNDJTJGdGQlM0UlM0MlMkZ0ciUzRSUwQSUwQSUwQSUwQSUwOSUzQ3RyJTNFJTNDdGQlMjBjb2xzcGFuJTNEJTI3MiUyNyUyMHN0eWxlJTNEJTI3dGV4dC1hbGlnbiUzQWNlbnRlciUzQiUyMHBhZGRpbmctdG9wJTNBMTVweCUzQiUyNyUzRSUwQSUwOSUwOSUzQ2lucHV0JTIwY2xhc3MlM0QlMjJjYm50JTIyJTIwdHlwZSUzRCUyN3N1Ym1pdCUyNyUyMHZhbHVlJTNEJTI3U3VibWl0JTI3JTIwJTJGJTNFJTBBJTA5JTA5JTNDaW5wdXQlMjBjbGFzcyUzRCUyMmNidG4lMjIlMjB0eXBlJTNEJTI3cmVzZXQlMjclMjAlMjB2YWx1ZSUzRCUyN1Jlc2V0JTI3JTIwJTJGJTNFJTBBJTA5JTIwJTIwJTIwJTIwJTNDJTJGdGQlM0UlMEElMDklM0MlMkZ0ciUzRSUwQSUyMCUyMCUyMCUzQyUyRnRhYmxlJTNFJTBBJTIwJTIwJTBBJTIwJTIwJTBBJTBBJTBBJTBBJTA5JTNDJTJGZm9ybSUzRSUwQSUzQyUyRmRpdiUzRSUwQSUwQSUzQ2RpdiUyMGlkJTNEJTI3bmV3ZGl2JTI3JTIwc3R5bGUlM0QlMjdkaXNwbGF5JTNBbm9uZSUzQmNvbG9yJTNBcmVkJTNCTWFyZ2luJTNBMCUyMGF1dG8lM0IlMjclM0UlMEElM0NoMSUyMHN0eWxlJTNEJTIyY29sb3IlM0FyZWQlMjIlM0UlMjAlM0NjZW50ZXIlM0UlMjBUaGFuayUyMFlvdSUyMSUzQyUyRmNlbnRlciUzRSUzQyUyRmgxJTNFJTBBJTNDaDIlMjBzdHlsZSUzRCUyMmNvbG9yJTNBcmVkJTIyJTNFJTIwJTNDY2VudGVyJTNFJTIwWW91ciUyMG1lc3NhZ2UlMjBoYXMlMjBiZWVuJTIwc3VjY2Vzc2Z1bGx5JTIwc2VudC4lMjBXZSUyMHdpbGwlMjBjb250YWN0JTIweW91JTIwdmVyeSUyMHNvb24lMjElMjAlMjAlM0MlMkZjZW50ZXIlM0UlM0MlMkZoMiUzRSUwQSUzQ2gxJTIwc3R5bGUlM0QlMjJjb2xvciUzQXJlZCUyMiUzRSUyMCUzQ2NlbnRlciUzRSUyMEhhcHB5JTIwTGVhcm5pbmclMjAlM0MlMkZjZW50ZXIlM0UlMjAlM0MlMkZoMSUzRSUwQSUzQyUyRmRpdiUzRSUwQSUwOSUzQ3NjcmlwdCUzRSUwQSUyMCUwOSUyMCUyMHZhciUyMG1uZEZpbGVkcyUzRG5ldyUyMEFycmF5JTI4JTI3RW1haWwlMjclMkMlMjdMYXN0JTIwTmFtZSUyNyUyQyUyN1Bob25lJTI3JTI5JTNCJTBBJTIwJTA5JTIwJTIwdmFyJTIwZmxkTGFuZ1ZhbCUzRG5ldyUyMEFycmF5JTI4JTI3RW1haWwlMjclMkMlMjdMYXN0JTIwTmFtZSUyNyUyQyUyN1Bob25lJTI3JTI5JTNCJTBBJTA5JTA5dmFyJTIwbmFtZSUzRCUyNyUyNyUzQiUwQSUwOSUwOXZhciUyMGVtYWlsJTNEJTI3JTI3JTNCJTBBJTBBJTIwJTA5JTIwJTIwZnVuY3Rpb24lMjBjaGVja01hbmRhdG9yeSUyOCUyOSUyMCU3QiUwQSUwOSUwOWZvciUyOGklM0QwJTNCaSUzQ21uZEZpbGVkcy5sZW5ndGglM0JpJTJCJTJCJTI5JTIwJTdCJTBBJTA5JTA5JTIwJTIwdmFyJTIwZmllbGRPYmolM0Rkb2N1bWVudC5mb3JtcyU1QiUyN1dlYlRvTGVhZHM4NzU3NDAwMDAwMDAyNjcwMDUlMjclNUQlNUJtbmRGaWxlZHMlNUJpJTVEJTVEJTNCJTBBJTA5JTA5JTIwJTIwaWYlMjhmaWVsZE9iaiUyOSUyMCU3QiUwQSUwOSUwOSUwOWlmJTIwJTI4JTI4JTI4ZmllbGRPYmoudmFsdWUlMjkucmVwbGFjZSUyOCUyRiU1RSU1Q3MlMkIlN0MlNUNzJTJCJTI0JTJGZyUyQyUyMCUyNyUyNyUyOSUyOS5sZW5ndGglM0QlM0QwJTI5JTIwJTdCJTBBJTA5JTA5JTA5JTIwaWYlMjhmaWVsZE9iai50eXBlJTIwJTNEJTNEJTI3ZmlsZSUyNyUyOSUwQSUwOSUwOSUwOSUwOSU3QiUyMCUwQSUwOSUwOSUwOSUwOSUyMGFsZXJ0JTI4JTI3UGxlYXNlJTIwc2VsZWN0JTIwYSUyMGZpbGUlMjB0byUyMHVwbG9hZC4lMjclMjklM0IlMjAlMEElMDklMDklMDklMDklMjBmaWVsZE9iai5mb2N1cyUyOCUyOSUzQiUyMCUwQSUwOSUwOSUwOSUwOSUyMHJldHVybiUyMGZhbHNlJTNCJTBBJTA5JTA5JTA5JTA5JTdEJTIwJTBBJTA5JTA5JTA5YWxlcnQlMjhmbGRMYW5nVmFsJTVCaSU1RCUyMCUyQiUyNyUyMGNhbm5vdCUyMGJlJTIwZW1wdHkuJTI3JTI5JTNCJTIwJTBBJTIwJTIwJTIwJTA5JTIwJTIwJTIwJTA5JTIwJTIwJTA5JTIwJTIwZmllbGRPYmouZm9jdXMlMjglMjklM0IlMEElMjAlMjAlMjAlMDklMjAlMjAlMjAlMDklMjAlMjAlMDklMjAlMjByZXR1cm4lMjBmYWxzZSUzQiUwQSUwOSUwOSUwOSU3RCUyMCUyMGVsc2UlMjBpZiUyOGZpZWxkT2JqLm5vZGVOYW1lJTNEJTNEJTI3U0VMRUNUJTI3JTI5JTIwJTdCJTBBJTIwJTIwJTA5JTIwJTIwJTIwJTA5JTIwJTIwJTIwJTA5JTIwaWYlMjhmaWVsZE9iai5vcHRpb25zJTVCZmllbGRPYmouc2VsZWN0ZWRJbmRleCU1RC52YWx1ZSUzRCUzRCUyNy1Ob25lLSUyNyUyOSUyMCU3QiUwQSUwOSUwOSUwOSUwOWFsZXJ0JTI4ZmxkTGFuZ1ZhbCU1QmklNUQlMjAlMkIlMjclMjBjYW5ub3QlMjBiZSUyMG5vbmUuJTI3JTI5JTNCJTIwJTBBJTA5JTA5JTA5JTA5ZmllbGRPYmouZm9jdXMlMjglMjklM0IlMEElMDklMDklMDklMDlyZXR1cm4lMjBmYWxzZSUzQiUwQSUwOSUwOSUwOSUyMCUyMCUyMCU3RCUwQSUwOSUwOSUwOSU3RCUyMGVsc2UlMjBpZiUyOGZpZWxkT2JqLnR5cGUlMjAlM0QlM0QlMjdjaGVja2JveCUyNyUyOSU3QiUwQSUyMCUwOSUyMCUwOSUyMCUwOSUyMGlmJTI4ZmllbGRPYmouY2hlY2tlZCUyMCUzRCUzRCUyMGZhbHNlJTI5JTdCJTBBJTA5JTA5JTA5JTA5YWxlcnQlMjglMjdQbGVhc2UlMjBhY2NlcHQlMjAlMjAlMjclMkJmbGRMYW5nVmFsJTVCaSU1RCUyOSUzQiUwQSUwOSUwOSUwOSUwOWZpZWxkT2JqLmZvY3VzJTI4JTI5JTNCJTBBJTA5JTA5JTA5JTA5cmV0dXJuJTIwZmFsc2UlM0IlMEElMDklMDklMDklMjAlMjAlMjAlN0QlMjAlMEElMDklMDklMDklMjAlN0QlMjAlMEElMDklMDklMDklMjB0cnklMjAlN0IlMEElMDklMDklMDklMjAlMjAlMjAlMjAlMjBpZiUyOGZpZWxkT2JqLm5hbWUlMjAlM0QlM0QlMjAlMjdMYXN0JTIwTmFtZSUyNyUyOSUyMCU3QiUwQSUwOSUwOSUwOSUwOW5hbWUlMjAlM0QlMjBmaWVsZE9iai52YWx1ZSUzQiUwQSUyMCUwOSUyMCUwOSUyMCUwOSUyMCUyMCUyMCUyMCU3RCUwQSUwOSUwOSUwOSU3RCUyMGNhdGNoJTIwJTI4ZSUyOSUyMCU3QiU3RCUwQSUwOSUwOSUyMCUyMCUyMCUyMCU3RCUwQSUwOSUwOSU3RCUwQSUwOSUwOWRvY3VtZW50LmdldEVsZW1lbnRCeUlkJTI4JTI3Y3JtV2ViVG9FbnRpdHlGb3JtJTI3JTI5LnN0eWxlLmRpc3BsYXklM0QlMjdub25lJTI3JTNCJTBBJTA5JTA5ZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQlMjglMjd1cmwlMjclMjkudmFsdWUlMjAlM0QlMjBkb2N1bWVudC5VUkwlM0IlMEElMDklMDlkb2N1bWVudC5nZXRFbGVtZW50QnlJZCUyOCUyN3JldHVyblVSTCUyNyUyOS52YWx1ZSUyMCUzRCUyMGRvY3VtZW50LlVSTCUyQiUyNyUyM25ld2RpdiUzRmklM0QxJTI3JTBBJTA5JTA5JTBBJTA5JTA5JTBBJTA5JTA5JTBBJTA5JTIwJTIwJTIwJTIwJTIwJTdEJTBBJTA5JTA5JTIwJTBBJTA5JTA5JTIwJTIwJTIwJTIwJTIwZnVuY3Rpb24lMjBnZXRQYXJhbWV0ZXJCeU5hbWUlMjhuYW1lJTJDJTIwdXJsJTI5JTIwJTdCJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwaWYlMjAlMjglMjF1cmwlMjklMjB1cmwlMjAlM0QlMjB3aW5kb3cubG9jYXRpb24uaHJlZiUzQiUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMG5hbWUlMjAlM0QlMjBuYW1lLnJlcGxhY2UlMjglMkYlNUIlNUMlNUIlNUMlNUQlNUQlMkZnJTJDJTIwJTIyJTVDJTVDJTI0JTI2JTIyJTI5JTNCJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwdmFyJTIwcmVnZXglMjAlM0QlMjBuZXclMjBSZWdFeHAlMjglMjIlNUIlM0YlMjYlNUQlMjIlMjAlMkIlMjBuYW1lJTIwJTJCJTIwJTIyJTI4JTNEJTI4JTVCJTVFJTI2JTIzJTVEJTJBJTI5JTdDJTI2JTdDJTIzJTdDJTI0JTI5JTIyJTI5JTJDJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwcmVzdWx0cyUyMCUzRCUyMHJlZ2V4LmV4ZWMlMjh1cmwlMjklM0IlMEElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjBpZiUyMCUyOCUyMXJlc3VsdHMlMjklMjByZXR1cm4lMjBudWxsJTNCJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwaWYlMjAlMjglMjFyZXN1bHRzJTVCMiU1RCUyOSUyMHJldHVybiUyMCUyNyUyNyUzQiUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMHJldHVybiUyMGRlY29kZVVSSUNvbXBvbmVudCUyOHJlc3VsdHMlNUIyJTVELnJlcGxhY2UlMjglMkYlNUMlMkIlMkZnJTJDJTIwJTIyJTIwJTIyJTI5JTI5JTNCJTBBJTIwJTIwJTIwJTIwJTdEJTBBJTA5JTBBJTA5JTA5JTIwalF1ZXJ5JTI4ZG9jdW1lbnQlMjkucmVhZHklMjhmdW5jdGlvbiUyMCUyOCUyNCUyOSUyMCU3QiUwQSUwQSUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMHZhciUyMGl2YWwlMjAlM0QlMjBnZXRQYXJhbWV0ZXJCeU5hbWUlMjglMjdpJTI3JTI5JTNCJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwaWYlMjAlMjhwYXJzZUludCUyOGl2YWwlMjklMjAlM0UlMjAwJTI5JTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTdCJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQlMjglMjdjcm1XZWJUb0VudGl0eUZvcm0lMjclMjkuc3R5bGUuZGlzcGxheSUyMCUzRCUyMCUyN25vbmUlMjclM0IlMEElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjBkb2N1bWVudC5nZXRFbGVtZW50QnlJZCUyOCUyN25ld2RpdiUyNyUyOS5zdHlsZS5kaXNwbGF5JTIwJTNEJTIwJTI3aW5saW5lJTI3JTNCJTBBJTA5JTA5JTA5JTIwJTIwJTIwJTI0JTI4JTI3aHRtbCUyQyUyMGJvZHklMjclMjkuYW5pbWF0ZSUyOCU3QiUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMHNjcm9sbFRvcCUzQSUyMCUyNCUyOCUyNyUyM25ld2RpdiUyNyUyOS5vZmZzZXQlMjglMjkudG9wJTBBJTIwJTIwJTIwJTIwJTdEJTJDJTIwJTI3c2xvdyUyNyUyOSUzQiUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCU3RCUwQSUwQSUwQSUwQSUyMCUyMCUyMCUyMCUwQSUwQSUyMCUyMCUyMCUyMCU3RCUwQSUyMCUyMCUyMCUyMCUyOSUzQiUwQSUwOSUyMCUyMCUyMCUwQSUzQyUyRnNjcmlwdCUzRSUwQSUzQyUyRmJvZHklM0UlMEElM0MlMkZodG1sJTNFJTBB