Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Update a Table Row with a Record
How To Update a Table Row with a Record? - Oracle DBA FAQ - Working with Database Objects in PL/SQL
✍: FYIcenter.com
If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample script below:
CREATE TABLE emp_temp AS SELECT * FROM employees; CREATE OR REPLACE PROCEDURE FYI_CENTER AS manager employees%ROWTYPE; BEGIN SELECT * INTO manager FROM employees WHERE employee_id = 100; manager.employee_id := 299; INSERT INTO emp_temp VALUES manager; manager.first_name := 'FYI'; manager.last_name := 'Center'; UPDATE emp_temp SET ROW = manager WHERE employee_id = 299; DBMS_OUTPUT.PUT_LINE('# rows updated = ' || SQL%ROWCOUNT); END; / # rows updated = 1
2007-04-26, 5010👍, 0💬
Popular Posts:
Can we have static indexer in C# ? No.
How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql ...
What are database triggers? How are the triggers fired? Read this collection of questions and answer...
When does the compiler not implicitly generate the address of the first element of an array? Wheneve...
What is PMP(project management plan)? The project management plan is a document that describes the p...