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

List out the types of joins.

0 Answers  

---

How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,

---

Difference between cartesian join and cross join?

0 Answers  

---

What happens to the current transaction if the session is ended?

0 Answers  

---

How to find the duplicate rows count from employees table in oracle?

0 Answers  

---

How can we find the size of a database?

2 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

---

How to see free space of each tablespace?

0 Answers  

---

what is the difference between no rows returned and null returned?

2 Answers  

---

What is Database Trigger ?

1 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 Answers  

---