answersLogoWhite

0

RECORD type works only in PL/SQL. But OBJECT type gets stored in database and can be used in both SQL and PL/SQL (without redefining it in PL/SQL).

User Avatar

Wiki User

14y ago

What else can I help you with?

Continue Learning about Information Science

What is the difference between flat-file model and database model?

The flat-file model stores data in a single table or file without any relationships between tables. In contrast, the database model organizes data into multiple interrelated tables with defined relationships, providing more flexibility, security, and scalability. Databases also offer features like data integrity enforcement, concurrency control, and support for complex queries.


What is the difference between a model-driven and data-driven DSS?

A model-driven DSS relies on mathematical or statistical models to analyze data and make predictions, while a data-driven DSS uses historical and real-time data to generate insights and support decision-making without relying heavily on predefined models. Model-driven DSS are more structured and use algorithms to process data, while data-driven DSS focus on exploring patterns and trends in data to inform decisions.


What are the difference between hierarchical database and network database?

Hierarchical databases organize data in a tree-like structure with parent-child relationships and a strict one-to-many hierarchy, while network databases use a more flexible model with many-to-many relationships through pointers or links between records. Hierarchical databases are faster for accessing data along predefined paths, while network databases allow for more complex data relationships but can be more complex to manage.


Difference between research method and search model?

A research method refers to the approach or technique used to conduct a study, encompassing procedures for data collection, analysis, and interpretation. On the other hand, a search model pertains to a theoretical framework that outlines the process by which information is retrieved and selected in a search process. While research methods deal with the overall research design, search models specifically focus on information retrieval processes.


Difference between hierarchical and Network data module?

The hierarchical data model organizes data in a tree-like structure with a single parent for each child record. On the other hand, the network data model allows for multiple parent-child relationships, creating a more flexible and complex network of interconnected records. In the hierarchical model, relationships are one-to-many, while in the network model, relationships can be many-to-many.