is there any special script to insert into Oracle cluster table

Question

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.

score 1 · Accepted Answer · answered Jul 19 '18 at 07:21

1

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;

answered Jul 19 '18 at 07:21

Littlefoot

131,892
15
35
57

so how to validate that insertion or updation (dml operation) has successfully executed. – Saumya Ranjan Jul 19 '18 at 09:08
Using a SELECT? – Littlefoot Jul 19 '18 at 09:38

is there any special script to insert into Oracle cluster table

1 Answers1