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
UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem