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 Insert a Record into a Table
How To Insert a Record into a Table? - 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 insert a row to this table with this RECORD variable using the INSERT statement as shown in the example 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; DBMS_OUTPUT.PUT_LINE('# rows inserted = ' || SQL%ROWCOUNT); END; / # rows inserted = 1
2007-04-26, 4826👍, 0💬
Popular Posts:
Have you ever worked with Microsoft Application Blocks, if yes then which? Application Blocks are C#...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
Which bit wise operator is suitable for checking whether a particular bit is on or off? The bitwise ...
When should the register modifier be used? Does it really help? The register modifier hints to the c...
What is synchronization and why is it important? With respect to multithreading, synchronization is ...