Browsing category PL/SQL

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

Introduction to PL/SQL (Lexical Units & Operator)


Lexical Units: Lexical units include letters, numerals, special characters, tabs, spaces, returns and symbol that building a PL/SQL block. Lexical unit can classified as following… Identifier Delimiters Literals Comments Identifier: Identifier are the names given to PL/SQL objects. Quoted Identifier: Quoted identifier makes identifier case sensitive, include character such as space and use reserved words.

Introduction to PL/SQL (Composite Data Type)


Composite data type: Composite data type stores values that have internal components. You can pass entire composite variables to subprograms as parameters, and you can access internal components of composite variables individually. Internal components can be either scalar or composite. You can use scalar components wherever you can use scalar variables or you can use

Follow Me

Oracle Certification