write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

How can you Enforce Referential Integrity in snapshots ?

1 Answers  

---

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

Explain enable novalidate constraint.

0 Answers  

---

What is meant by joins? List out the types of joins.

0 Answers  

---

How to define an explicit cursor in oracle?

0 Answers  

---

Do View contain Data ?

10 Answers  

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

0 Answers  

---

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

---

What is object data modeling?

0 Answers  

---

How to add another datafile to a tablespace?

0 Answers  

---