true

Learn PL/SQL from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Some Interesting and important built in packages in Oracle

Gavi Y.

09/01/2017 0 0

DBMS_JOB : To schedule jobs.

DBMS_SCHEDULER: Extended the functionalities of DBMS_JOB.

UTL_SMTP: To send mails.

UTL_HTTP: To open Web APIs (URLs).

DBMS_LOB: Very interesting and useful. Programmatic interface to deal with Large objects like Clob, Nclob, Blob and Bfile

DBMS_UTILITY: Wide range of functionalities. Check format_error_backtrace, format_call_stack, format_error_stack etc.

UTL_FILE: File handling.

DBMS_REDIFINITION: Online redefinition of tables. To partition an existing table etc

DBMS_WORKLOAD_REPOSITORY: Used in performance tuning to generate/drop snapshopts, to create/remove baselines, to change snapshot settings etc which can be further used in generating the AWR reports.

DBMS_SQL: Dynamic SQL support

DBMS_XPLAN: Format the output of explain plan.

0 Like 0 Dislike

Follow 0

Other Lessons for You

What is DBMS and RDBMS

Database Management Systems A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses...

Amit Patil

0 0

DBMS - SQL - Any/All

All - Operator SELECT empno, sal FROM emp WHERE sal > ALL (1999, 2999, 3999); Output of Above query is same as below query SELECT empno, sal FROM emp WHERE sal > 1999 AND sal > 2999...

Radhe Shyam

0 0

WebSphere

WebSphere is a set of Java-based tools from IBM that allows customers to create and manage sophisticated business Web sites. The central WebSphere tool is theWebSphere Application Server (WAS), an application...

ITech Analytic Solutions

0 0

Datastage: DB2 Indirect Privileges For Stored Procedures

1. I recently updated a Datastage job to use a direct Update query instead of calling a Stored Procedure(SP) through the job which had the Update query.2. The result: The job failed with the error that...

Kriti C.

1 0

What is PowerPoint?

PowerPoint is a complete presentation graphics package. It gives you everything you need to produce a professional-looking presentation. PowerPoint offers word processing, outlining, drawing, graphing,...

ITech Analytic Solutions

0 0

Find PL/SQL Classes near you

Looking for PL/SQL Classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

PL/SQL Questions

I need your help to choose my career as I have three years of gap between my education. I know SQL. Can...

28 Answers

Looking for PL/SQL Classes?

The best tutors for PL/SQL Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn PL/SQL with the Best Tutors

The best Tutors for PL/SQL Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.