Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does PL/SQL Have User-Defined Types or Abstract Data Types?

April 26, 2017abstract Data PL sql types User-defined

0

Posted

Does PL/SQL Have User-Defined Types or Abstract Data Types?

1 Answer

0

Posted

The PL/SQL term for these things is “object types”. To do object-oriented programming, you use a mix of SQL and PL/SQL. You create the types themselves and the tables to hold them using SQL. You write the bodies of the methods in PL/SQL, and you can also manipulate tables of objects and call object methods through PL/SQL. The best source of information for object-oriented programming with PL/SQL is the book Oracle Database Application Developer’s Guide – Object-Relational Features.