what's query optimization and without use of IN AND Exist can we get another way data from query

0 Answers  

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

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  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  

---

Explain what does a control file contain?

0 Answers  

---

What is an oracle?

0 Answers  

---

Can we create trigger on view in oracle?

1 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

What does COMMIT do ?

4 Answers  

---

candidate key is subset of super key but not vice-verse explain

0 Answers  

---

What suggestions do you have to reduce the network traffic?

0 Answers  

---