1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---

How to delete a user account in oracle?

0 Answers  

---

Explain the difference between a procedure and a function?

0 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---

how to see the data (in unix) using dataset in datastage?

1 Answers   iGate,

---

what are corelated subqueries

1 Answers   Global Infotech,

---

What is the difference between a user and a schema in oracle?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

0 Answers   ESS,

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---