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

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

Mail Merge In Word

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...

ITech Analytic Solutions

0 0

Oracle Database 23 AI New Features

Vinayak V Dabgar

2 0

Write a query

To find out how many 'a' characters are present in the string 'database'?

Praneeth Vasantha

0 0

Amazon written test for experience

For the below written test answer I defined with "*" at the end of the options NULL is the same as 0 for integer the same as blank for character * the same as 0 for integer and blank for character the...

Suresh

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.