What are the data types in oracle?

0 Answers  

---

when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

What is different types of joins?

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  

---

Difference between cartesian join and cross join?

0 Answers  

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

What is a Data Segment ?

3 Answers  

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

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,

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---