how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

What are the different types of joins in sql?

3 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

What is use of package in pl sql?

0 Answers  

---

Can you inner join the same table?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

What is sql and also describe types of sql statements?

0 Answers  

---