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
10393 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

What is pessimistic concurrency control? : Transact sql

1070

How many types of literals are available in pl sql?

1099

What is benefit of creating memory optimized table?

955

What is the purpose of design view?

999

What is cost in sql execution plan?

965

Is sql dba a good career? : SQL DBA

976

How do I run a sql script?

1121

Why we use pl sql?

943

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1042

Why procedure is used in sql?

1026

How to handle bulk data?

1299

Is inner join faster than left join?

1172

what is a constraint? : Sql dba

1126

what is view? : Sql dba

942

what is the difference between blob and text? : Sql dba

1003