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
Literature review

Create a Oracle procedure to produce vertical output format when selecting rows from a database table.

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

Application to Export Excel Data to MSSQL Server table I am having a table available in excel format and features the subsequent: - Some text is in Arabic (e.g. UTF-8 encodin

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Name Resolution In potentially uncertain SQL statements, the names of the database columns take precedence over the names of the local variables and formal parameters. For e.g.