PL/SQL

Sending E-mail with Excel Attachment Using UTL_SMTP

The utl_smtp package is used to send e-mails from any database to a valid recipient/receipents with or without attachements.The generic code is given to send e-mail with excel attachment ,…

Read More

Load XML data into Oracle table

Steps to Load XML File to Oracle Tables Solution : Sample XML file has been used for illustration Step 1 : Create a directory using the below command. The below…

Read More