Browsing category Oracle Database

How to send mail from Oracle APEX


In this tutorial i will show you how to send mail from Oracle APEX. Lets start…. This tutorial divide into tree parts- Configure mail server Enabling network services Test mail 1. Configure mail server: Before you configure Oracle APEX mail server you need to a SMTP mail server username and password. Then login your oracle

Tips and Tricks – 1


1. Create unique case-insensitive constraint on a column. Solution: Add function level unique index, example –

2. Cannot create service/sid using ORADIM (DIM-00019: create service error O/S-Error: (OS 5) Access is denied.) Solution: Make sure your oracle service is running. then create instance. To create instance- Open CMD (command prompt) with admin privilege. the type the

Enable network service (ACL) and Send mail from APEX


Enabling Network Service: By default, the ability to interact with network services is disabled in Oracle Database 11g. Therefore, you must use the BMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for the APEX_040200 database user:

Send Mail: Oracle application express send mail using APEX_MAIL package. example…

Send mail with attachments…

Introduction to PL/SQL (Control Structure)


Control Structure: This chapter shows you how to structure the flow of control through a PL/SQL program. There are three types of Control structure available in PL/SQL, These are Conditional constructs with the IF statements, CASE expression and LOOP control structure. IF Statements: In Oracle, the IF-THEN-ELSE statement is used to execute code when a

Introduction to PL/SQL (SQL Statements)


SQL Statements in PL/SQL: PL/SQL supports data manipulation language (DML) and transaction control language (COMMIT, ROLLBACK, SAVEPOINT). You can use DML commands to modify the data in a database table. PL/SQL dose not directly support DDL statements, such as – CREATE TABLE, ALTER TABLE, DROP TABLE. These statements are dynamic SQL statements. Dynamic statements are

Follow Me

Oracle Certification