How to assign a tablespace to a users in oracle?

0 Answers  

---

What is an Index Segment ?

2 Answers  

---

Why do we use coalesce function in oracle?

0 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

Can we create more than one index on particular column?

1 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

Explain oracle left join with an example?

0 Answers  

---

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

1 Answers  

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---