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,

---

what is Single Byte Overhead...?

0 Answers  

---

What are the restrictions on external table columns?

0 Answers  

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers   TCS,

---

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

How to connect to the server with user account: sys?

0 Answers  

---

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

---

How to drop an existing view in oracle?

0 Answers  

---