Data types, PL-SQL Programming

Datatypes

Every constant and variable has a datatype that specifies the storage format, constraints, and the valid range of values. The PL/SQL gives a variety of predefined datatypes. The scalar type has no internal components. The composite type has internal components which can be manipulated separately. A reference type holds values, known as the pointers that designate other program items. A LOB type holds values, known as the lob locators that specify the location of large objects stored out-of-line.

Figure represents the predefined datatypes available for your use. The scalar types fall into 4 families that store number, Boolean, character, and date/time data, respectively.

 

675_data types.png

Posted Date: 10/2/2012 2:28:48 AM | Location : United States







Related Discussions:- Data types, Assignment Help, Ask Question on Data types, Get Answer, Expert's Help, Data types Discussions

Write discussion on Data types
Your posts are moderated
Related Questions

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons:

The Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to t

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

What are the rates for help in writing PL/SQL procedures and functions?

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv