by using sub_str fuction we can do this select sub_str(task

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

Question Posted / chandu

6 Answers
10481 Views
I also Faced
E-Mail Answers

Answer Posted / chandu

by using sub_str fuction we can do this

select sub_str(task_number,6) from pa_tasks.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sqlite need a server?

1055

how to increment dates by 1 in mysql? : Sql dba

984

What is a unique constraint?

1081

What is schema in sql example?

1186

What is meant by truncate in sql?

1070

Why should I use postgresql?

1023

what is unique key constraint? : Sql dba

1045

How can you load microsoft excel data into oracle? : aql loader

1179

Is mariadb nosql?

1045

What are the types of records?

992

Mention what pl/sql package consists of?

1006

What is the clause we need to add in function body to return variable?

1015

Which is faster joins or subqueries?

992

When is the update_statistics command used?

1127

What is sp_helptext?

1071