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
Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

Scope Rules You cannot declare an exception twice in the similar block. Though, you can, declare the similar exception in 2 different blocks. The Exceptions declared in a bloc

Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.

Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

What are the rates for help in writing PL/SQL procedures and functions?

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t