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
Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO

Understanding Varrays The Items of type VARRAY are termed as the varrays. They permit you to relate a single identifier with the whole collection. This relationship lets you man

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

PPD , CPA, Filesharing Site Project Description: This is very easy I need a PPD , CPA, Filesharing Site. [PPD] stands for (pay per download) example hotsharecash [Files

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me

Use Native Dynamic SQL A few programs (a normal-purpose report writer for illustration) should build and process a variety of SQL statements at run time. Therefore, their full