What are the differences between blob and clob in oracle?

0 Answers  

---

What is tns entry?

0 Answers  

---

What is STATSPACK tool?

3 Answers   Wipro,

---

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 Answers   HCL, LN,

---

what is the syntax of DELETE command?

8 Answers  

---

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

---

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

0 Answers  

---

What is a system tablespace and when it is created?

0 Answers  

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

How to get a list of all user accounts in the database?

0 Answers  

---

What is pragma autonomous transaction in oracle?

0 Answers  

---