Updating plsql

Rated 3.97/5 based on 948 customer reviews

You need not specify the partition name when updating values in a partitioned table.

However in some cases specifying the partition name can be more efficient than a complicated Specify a complete or partial name of a database link to a remote database where the object is located.

DECLARE variable number; id number; description varchar2 (100); CURSOR C1 IS select regions.

REGION_ID variable from regions; BEGIN FOR R_C1 IN C1 LOOP BEGIN select regions. REGION_NAME into id,description from regions where regions.

where (column1,column2) in ( I didn't down rate, but it isn't a good solution.

Firstly: if the subselect was returning multiple values, then the for loop will be overwriting the name on table2 multiple times for some/all records (not clean). Assuming the outcome of the for loop was intended, the original subselect could have been rewritten in some controlled way to return only 1 value for each record...

Regardless of its form, it must return a collection value—that is, a value whose type is nested table or varray.You can use a database link to update a remote object only if you are using Oracle Database distributed functionality.If you omit to indicate that Oracle Database prohibits any changes to the table or view that would produce rows that are not included in the subquery.REGION_ID, regions.[description] FROM regions WHERE NOT EXISTS ( SELECT NULL FROM MAIN. This means that you have to select on all the fields which comprise a unique key -- a non-unique primary key is not sufficient.

Leave a Reply