Updating objects in pl sql, PL-SQL Programming

Updating Objects:

To change the attributes of objects in an object table, you can use the UPDATE statement, as the illustration below shows:

BEGIN

UPDATE persons p SET p.home_address = '341 Oakdene Ave'

WHERE p.last_name = 'Brody';

...

UPDATE persons p SET p = Person('Beth', 'Steinberg', ...)

WHERE p.last_name = 'Steinway';

...

END;

 

Posted Date: 10/6/2012 8:24:48 AM | Location : United States







Related Discussions:- Updating objects in pl sql, Assignment Help, Ask Question on Updating objects in pl sql, Get Answer, Expert's Help, Updating objects in pl sql Discussions

Write discussion on Updating objects in pl sql
Your posts are moderated
Related Questions
Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

Exception handling In the PL/SQL, a warning or error condition is known as an exception. The Exceptions can be internally defined (by the run-time system) or user defined. The

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

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

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of