Technology Questions

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.

- The maximum data rate supported by a GSM system is 9.6 kbps.
- However there are extensions to GSM standard to improve throughput.
- GPRS is one of the extended GSM service.
- The extended standards of GSM allows theoretical data rates on the order of 114 Kbit/s, but with throughput closer to 40Kbit/s in practice.

Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.

By using two types of function modules to be called in SAP Script:

1)HELP_OBJECT_SHOW_FOR_FIELD
2)HELP_OBJECT_SHOW

- GPRS uses 2.5 generation of GSM signals
- The radio interface is the same that of GSM
- GPRS uses 900 / 1800 Mhz, frequency band and GMSK modulation
- The bit rates are EGPRS, similar to EDGE
- Separate hardware and ports need to be added and availed.

HashCode method return int value. So the Hash value is the int value returned by the hash function .

If you want to do equality check or want to use your object as key in HashMap, we must override hashcode and equals() method.

The presentation of one or more views on a screen is coordinated by UIWindow object..

Type 4  (JDBC Net pure Java Driver) is the fastest JDBC driver.  Type 1 and Type 3 drivers will be slower than Type 2 drivers (the database calls are make at least three translations versus two), and Type 4 drivers are the fastest (only one translation).