Parameter and keyword description - insert statement, PL-SQL Programming

Parameter and Keyword Description: 

table_reference:

This identifies a table or view which should be available when you execute the INSERT statement, and for that you should have the INSERT privileges.

Subquery:

This is a SELECT statement which gives a set of rows for the processing. Its syntax is just similar to that of the select_into_statement without the INTO clause.

TABLE (subquery2):

The operand of the TABLE is a SELECT statement which returns a single column value, that should be the nested table or a varray cast as the nested table. The Operator TABLE informs the Oracle that the value is a collection, however not a scalar value.

Alias:

This is the other (generally short) name for the referenced table or a view.

column_name[, column_name]...:

This identifies a list of columns in the database table or view. The Column names need not appear in the order in which they were defined by the CREATE VIEW statement or CREATE TABLE. Though, no column name can appear more than once in the list. If the list does not involve all the columns in a table, the missing columns are set to the NULL or to a default value specified in the CREATE TABLE statement. 

sql_expression:

This is any expression valid in the SQL statement. 

VALUES (...):

These clauses assign the values of expressions to the corresponding columns in the column list. When there is no column list, the first value is inserted into the first column defined by the CREATE TABLE statement, and the second value is inserted into the second column, and so on. There should be only one value for each column in the column list. The first value is related with the first column; the second value is related with the second column, and so on. When there is no column list, you should supply a value for each column in the table. The values datatype being inserted should be compatible with the datatypes of the corresponding columns in the column list.

As numerous rows are added to the table as are returned by the subquery in the VALUES clause. The sub query should return a value for every column in the column list or for every column in the table when there is no column list.

subquery3:

This is a SELECT statement which gives a value or set of values to the VALUES clause. The sub query should return only one row containing a value for every column in the column list or for every column in the table when there is no column list.

returning_clause:

This clause returns values from the inserted rows, thus removing the need to SELECT the rows subsequently. You can retrieve the column values into the variables and/or host variables, or into the collections and/or host arrays. Though, you cannot use the RETURNING clause for the remote or parallel inserts. 

Posted Date: 10/8/2012 7:05:25 AM | Location : United States







Related Discussions:- Parameter and keyword description - insert statement, Assignment Help, Ask Question on Parameter and keyword description - insert statement, Get Answer, Expert's Help, Parameter and keyword description - insert statement Discussions

Write discussion on Parameter and keyword description - insert statement
Your posts are moderated
Related Questions
Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

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

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th