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
Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Biconditional - SQL The biconditional p ↔ q can be expressed in Tutorial D by p = q and the same is true of SQL. The question then arises as to whether, in SQL, p = q is equiv

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

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

Short-Circuit Evaluation When computing a logical expression, the PL/SQL uses short-circuit evaluation. That is, the PL/SQL stops computing the expression as soon as the result

I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write