Working with Collections in Oracle PL/SQL With Pankaj Jain

[xidau123 13]

Working with Collections in Oracle PL/SQL With Pankaj Jain

766MB | Duration: 4h 52m | Video: AVC (.mp4) 1024x768 15fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

 

Oracle's relational databases are used by thousands of companies around the globe. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL which allows us to procedurally tie SQL statements to effectively define business logic. In this course, we will talk about collection types available in PL/SQL. Collections Types are an extremely important part of any programming language. The collection types, along with providing a mechanism to conveniently handle sets of data, can also boost performance. Oracle offers a rich set of collection types in Associative Arrays, Varrays, and Nested Tables. We will take an in-depth look at these powerful datatypes and get familiar with the Oracle bulk fetch and collect features which greatly enhance the performance of our PL/SQL code.

 

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.