is there any special script to insert into Oracle cluster table

59 views Asked by At

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.

1

There are 1 answers

2
Littlefoot On BEST ANSWER

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;