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:


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';




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
Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con

Table Comparison - SQL The following definitions for relation comparisons: Let r1 and r2 be relations having the same heading. Then: r1 ⊆ r2 is true if every tuple of r1

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

LOB Types The large object (LOB) datatypes like BFILE, BLOB, CLOB, and NCLOB store the blocks of unstructured data (like graphic images, text, video clips, and sound waveforms)

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

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

Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

V ariables and Constants in PL/SQL The PL/SQL permits you to declare constants and variables, and then use them in SQL and procedural statements anywhere in the expression. Th