Data types in sql - xml, array, row, PL-SQL Programming

Data Types in SQL - XML, Array, Row

  1. BINARY LARGE OBJECT for arbitrarily large bit strings.
  2. XML for XML documents and fragments.
  3. ARRAY types for arrays.
  4. ROW types and MULTISET.

 

Posted Date: 1/18/2013 2:00:17 AM | Location : United States







Related Discussions:- Data types in sql - xml, array, row, Assignment Help, Ask Question on Data types in sql - xml, array, row, Get Answer, Expert's Help, Data types in sql - xml, array, row Discussions

Write discussion on Data types in sql - xml, array, row
Your posts are moderated
Related Questions
Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

heap sort program in pl/sql

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

SQL Pseudocolumns The PL/SQL recognizes the following SQL pseudocolumns, that returns the specific data items: LEVEL, NEXTVAL, CURRVAL, ROWID, & ROWNUM. The Pseudocolumns are n

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Variable Declaration - SQL SQL's support for variables is very similar to Tutorial D's, except that the syntax for creating persistent  variables-base tables-is quite differen

Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Initializing Objects: Till you initialize an object by calling the constructor for its object type, the object is automatically null. That is, the object itself is null, not me

Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc