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

Try too choose suitable industry which will give more happyness

In any industry, if its suitable and if its more interest then every body can create wonders. So let choose which is best suitable to you mean while dont think u want to become no 1. As per your capabilities,...

K C Reddy

0 0

Write a query

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

Praneeth Vasantha

0 0

Defect Management

Defect Management Terms: Application Life Cycle (ALM) Development Phase Testing Phase Production Phase ------------------------------------------------------------------ Error ...

Rahul

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

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.