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,

---

Find all employees in Dept “Marketing”.

2 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

---

What is use of oracle?

2 Answers   Satyam,

---

How are extents allocated to a segment?

0 Answers  

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

What is the dynamic sql in oracle?

0 Answers  

---

What is an Oracle Instance?

0 Answers  

---

How can I get column names from a table in oracle?

0 Answers  

---

How do I recompile a procedure in oracle?

0 Answers  

---