How to insert into oracle cluster tables and how to validate data inserted into that two tables correctly or not?
if I have two tables amp and dept. these two table is cluster table and share same data blocks. can I insert data into both table by simple insert statement.
can I insert data into both table by simple insert statement.
Yes, using INSERT ALL
, such as
insert all
into emp (empno, ename) values (1, 'Little')
into emp (empno, ename) values (2, 'Foot')
--
into dept (deptno, dname) values (100, 'IT')
select * from dual;