select substr(task_number,-2) from pa

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 / anju hajela

6 Answers
10452 Views
I also Faced
E-Mail Answers

Answer Posted / anju hajela

select substr(task_number,-2) from pa_task;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you know by pl/sql cursors?

1105

What are data types in pl sql?

1141

What does <> sql mean?

1085

What are types of indexes in sql?

1082

What is the maximum database size for sql express?

1023

What does a pl/sql package consist of?

974

How many joins in sql?

1008

which types of join is used in sql widely? : Sql dba

982

What is the difference between delete and truncate commands?

1037

what is single byte over head in oracle..?

2401

Is progress software supports to ( pl/sql )?

1037

what is a tablespace? : Sql dba

1051

How do you create an update query?

962

What is a crud api?

954

What is sqlerrd?

968