madhupalepu

 Profile Answers by madhupalepu 

• Apr 25th, 2008

 

create a view based on two tables columns,then insert into view,it will insert data into two tables automatically

jannaat

 Profile Answers by jannaat Questions by jannaat

• Apr 28th, 2008

 

insert all into t1(a)values(1)t2(b)values(2) select * from dual ;

Regards
Murali

Imran_Javed

 Profile Answers by Imran_Javed 

• May 8th, 2008

 

If there is any parent-child relation between the table, disable it first.

ALTER TABLE emp
DISABLE CONSTRAINT FK_DEPTNO;

/*Inserting data in two tables in a single query*/
INSERT ALL
INTO dept(DEPTNO, DNAME) VALUES (deptno , dname)
INTO emp (EMPNO, DEPTNO) VALUES (empno , deptno)
SELECT 10 empno , 60 deptno, 'Testing' dname
FROM dual;


ALTER TABLE emp
ENABLE CONSTRAINT FK_DEPTNO;

manavairajamohamed

 Profile Answers by manavairajamohamed 

• Jun 5th, 2008

 

How to inserrt a record to the two table in single query please Reply immed

manavairajamohamed

 Profile Answers by manavairajamohamed 

• Jun 5th, 2008

 

Insert into tblfirst(field1,field2)  select field1,field2  from tblsecond

chandra411

 Profile Answers by chandra411 

• Sep 2nd, 2008

 

Using merge concept, we can insert a record at a time into two tables.

Nazeera Jaffar

• Sep 30th, 2012

 

Answer:

Code
INSERT ALL


    INTO first_table VALUES(value1,value2)


     INTO second_table VALUES(value1,value2)


 


SELECT * FROM dual;