From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  

---

what is the dual table in oracle?

0 Answers  

---

does the query needs a hint to access a materialized view?

0 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

can we insert any row to dual table if i got the permission from DBA

5 Answers   HCL, Tesco,

---

Is oracle an operator?

0 Answers  

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---