Answer / sreenivasulu sangatipalli

SELECT REGEXP_SUBSTR(COL,'[A-B]+',COL) AS COL1,REGEXP_SUBSTR(COL,'[1-9]+',COL) AS COL2 FROM TEST10;
SELECT * FROM (SELECT CASE WHEN REGEXP_LIKE(COL,'[A-Z]+','i') THEN COL END ALPHS,
CASE WHEN REGEXP_LIKE(COL,'[0-9]+') THEN COL END NUMBS
FROM TEST10 ) where ALPHS is not null OR NUMBS is not null;

How do I install microsoft sql?

0 Answers  

---

How can you know that statistics should be updated?

0 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

How can a pl sql block be executed?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---

What is offset and limit in sql?

0 Answers  

---

What is ttitle and btitle?

0 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What does inner join mean?

0 Answers  

---

What is set serveroutput on?

0 Answers  

---