Answer / ankit

An insert all statement allows you to insert data into
multiple table with a single statement. For example:

INSERT ALL
INTO TABLE1(COLUMN1, COLUMN 2) VALUES('A','B')
INTO TABLE2(COLUMN 3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
FROM DUAL

Answer / sudip

INSERT ALL
INTO TABLE1(COLUMN1, COLUMN2) VALUES('A','B')
INTO TABLE2(COLUMN3,COLUMN4) VALUES ('1','2')
INTO TABLE3(COLUMN5,COLUMN6) VALUES ('2','A')
select * FROM DUAL

is database gud carrier option??

1 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

Design database draw er diagram for a certain scenario ?

0 Answers   Keane India Ltd, TATA,

---

How to call a stored function with parameters?

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  

---

Explain the use of online redo log files in oracle.

0 Answers  

---

What are synonyms used for ?

3 Answers  

---

What are the different type of Segments ?

2 Answers  

---

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

Please explain joins in oracle?

0 Answers  

---