What is an oracle user account?

0 Answers  

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

What is the difference between substr and instr?

0 Answers  

---

How to define a record variable to store a table row?

0 Answers  

---

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers  

---

Maximum how many triggers can be updated in table ?

5 Answers   Accenture, Cap Gemini,

---

Give the advantages and disadvantages of clusters.

0 Answers  

---

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

---