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
Cursors The Oracle uses work areas to execute the SQL statements and to store process information. A PL/SQL construct known as the cursor. Let's you assume name a work area and

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Using FIRST and LAST FIRST and LAST return the first and last (minimum and maximum) index numbers in a collection. When the collection is empty, the FIRST and LAST return NULL

what is the use of declare keyword

How Exceptions Are Raised By the run-time system, the internal exceptions are raised implicitly as are user-defined exceptions that you have related with an Oracle error number

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat