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

How To Prepare For OCA Exam?

Oracle Certified Associate certification programs are very costly to take the exam. They really deserve it because you get a high value of this certification in the job market. This Article is meant for...

Anupam Thakur

1 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

HTML (Hypertext Markup Language)

HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...

ITech Analytic Solutions

1 0

What is a SQL join?

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

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

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.