what is the difference between rollback & commit? can a foreign key has null value?

6 Answers  

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

---

Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,

---

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

What are the oracle built-in data types?

0 Answers  

---

What do you understand by database schema and what does it hold?

0 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

Define Transaction ?

5 Answers  

---

State and explain the different types of data models?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---