Nickel

Sundari

Barack Room Ballads

Toddy

AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

Benefits for organizations :

The BlackBerry Connect technology allows the organizations for standardizing BlackBerry platform and leverages their existing BlackBerry solution investments. The employees’ productivity and performance can also be boosted by providing them the mobile access for their emails and calendars.

Benefits for IT :

IT departments are provided with a solution that is easy to utilize, manage and deploy by using BlackBerry Connect technology. Strict requirements for security and manageability will be satisfied and several devices can be connected to the BlackBerry Platform. 

Function prototyping is a function declaration statement that tells the compiler about the return type of the function and the number as well as type of arguments required by the function at the time of calling it.

Syntax:

return_type function_name( type1 arg1, type 2 arg2, ... );

Advantages of function prototype :

- It helps the compiler in determining whether a function is called correctly or not. Each time when a function is called, its calling statement is compared with its prototype. In case of any mismatch, compiler reports an error.

- A function must be defined before calling it. But prototyping allows a function to be called before defining it.

A package is a collection of related PL/SQL objects. The package contains a body and a specification. The package specification has the declaration which is public and can be used in the PL/SQL sub programs inside the package.

The package body holds the implementation of all the PL/SQL objects declared in the specification.

Example of a PL/SQL Package.

CREATE OR REPLACE PACKAGE emp_data AS 

PROCEDURE add_employee (

      ename VARCHAR2,

      job VARCHAR2,

      mgr NUMBER,

      sal NUMBER,

      deptno NUMBER);

END emp_actions;

CREATE OR REPLACE PACKAGE BODY emp_data AS 

PROCEDURE add_employee (

       ename VARCHAR2,

       job VARCHAR2,

       mgr NUMBER,

       sal NUMBER,

       deptno NUMBER) IS

BEGIN

         INSERT INTO emp VALUES (empno_seq.NEXTVAL, ename, job, mgr, SYSDATE, comm, deptno);

END add_employee;

END emp_data;

Advantages of  PL/SQL packages :

Packages are easier for application designing, encapsulating data, additional functionality and better performance. An application has various modules which can be placed in packages and handled easier.