How do I save a sql query?

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

---

why should required for Indexed by table in pl/sql

3 Answers  

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

What are stuff and replace function?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---