Scribd
Upload
10 views1 page

Advantages of PL/SQL in DBMS

PL/SQL offers advantages like support for SQL, object-oriented programming, better performance by sending entire blocks of statements to Oracle at once, higher productivity through better tools, full portability across Oracle platforms, tight integration with Oracle security, and ability to achieve data abstraction and access control. Large objects (LOBs) in Oracle can hold extremely large amounts of data, up to terabytes, are used to store graphics, video or audio data efficiently, and provide uniform access to data stored within or outside the database.

Uploaded by

harryharsan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
10 views1 page

Advantages of PL/SQL in DBMS

PL/SQL offers advantages like support for SQL, object-oriented programming, better performance by sending entire blocks of statements to Oracle at once, higher productivity through better tools, full portability across Oracle platforms, tight integration with Oracle security, and ability to achieve data abstraction and access control. Large objects (LOBs) in Oracle can hold extremely large amounts of data, up to terabytes, are used to store graphics, video or audio data efficiently, and provide uniform access to data stored within or outside the database.

Uploaded by

harryharsan
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1. Explain the advantages of PL/SQL.

PL/SQL is a transaction processing language that offers the following advantages: support for SQL - SQL is flexible, powerful and easy to learn. support for object-oriented programming better performance - with PL/SQL, an entire block of statements can be sent to Oracle at one time. higher productivity - PL/SQL increases productivity by enabling use of better tools. full portability - PL/SQL are portable to any operating system and platform on which Oracle runs. tight integration with Oracle security PL/SQL can achieve data abstraction, access control.

2. What is large object in oracle? Explain its purposes.


Large objects (LOBs) are exclusively used to hold large amounts of data. It can hold data in tetra bytes. Different types of LOBs include internal, external, persistent and temporary. Binary LOBs are typically used to store graphics, video, or audio data. Purpose: Enables you to access and manipulate the data efficiently in your application Is optimized for large amounts of data Provides a uniform way of accessing data stored within the database or outside the database

You might also like