Lida Gholizadeh

Today, I had the opportunity to attend the Oracle CloudWorld Tour in Frankfurt, held at the Congress Center Messe Frankfurt. This free, one-day event was an important stop on Oracle's global tour, bringing together technology experts, business leaders, and professionals to explore the latest advancements in cloud computing and artificial intelligence (AI). 👀 I recorded a short video below just to show the environment and atmosphere watch It! https://www.youtube.com/watch?v=-zRCkJB6qw8 The event offered deep insights into how Oracle’s cloud infrastructure and AI services are transforming industries. The sessions covered key topics such as automation, data analytics, and the integration of AI into business processes—showcasing the real-world impact of these technologies. One of the highlights was the hands-on demonstrations, where participants could explore Oracle’s latest innovations and learn about their practical applications and benefits. These interactive experiences made the t...

⍰    What is SYS.ODCI...? Oracle database provides predefined collection types, such as  SYS.ODCINUMBERLIST and SYS.ODCIVARCHAR2LIST , which simplifies operations involving lists of numbers or strings.  SYS.ODCI  designed for bulk operations   and they  are nested table types that store lists of numbers and strings,  respectively.  ⍰    Can we use  SYS.ODCI  instead of  TABLE OF  Types ? In some cases, you can use SYS.ODCI types like instead of defining your own nested table types. For example, if you need a collection of numbers or strings, you can use these system types instead of defining something like this yourself because User-defined types require explicit definitions. In contrast, SYS.ODCINUMBERLIST and similar predefined types are readily available and can be used both in PL/SQL and SQL contexts without additional definitions. But In general,  For more complex structures (like objects with multiple...