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

Assignment Help:

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. 


Related Discussions:- Parameter and keyword description - insert statement

Forward declarations - subprograms, Forward Declarations The PL/SQL ne...

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

Parameter and keyword description - procedures, Parameter and Keyword Descr...

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Parameter and keyword description - %type attribute, Parameter and Keyword ...

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

Using extend - collection method, Using EXTEND To enlarge the size of ...

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

Exit statement - syntax, EXIT Statement   You can use the EXIT stateme...

EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

In mode - parameter modes, IN Mode An IN parameter pass the values to ...

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Third step at defining type sid in sql, Third Step at defining type SID in ...

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE

Advantages of invoker rights, Advantages of Invoker Rights The Invoker-...

Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

Update the Status of an Ordere, Create a procedure named STATUS_SHIP_SP tha...

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Implicit cursors, Implicit Cursors The Oracle implicitly opens a curso...

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd