Dear friend , you can use this select statement:- select trim(translat

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 / hitendra yadav

6 Answers
10630 Views
I also Faced
E-Mail Answers

Answer Posted / hitendra yadav

Dear friend
,
you can use this select statement:-

select trim(translate(TASK_NUMBER,'.0123456789',' ')) from
PA_TASKS;
For example:-
select trim(translate('1.1.3NN','.0123456789',' ')) from
dual;

it will give NN as output

if value format same like this then you can use substr
function also for it like this:-
select substr(TASK_NUMBER,-2) from PA_TASKS ;
For example:-

select substr('1.1.3NN',-2) from dual;

it will give NN as answer.

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the advantages of mysql in comparison to oracle? : Sql dba

1044

what is difference between delete and truncate commands? : Sql dba

1169

Define union, minus, union all, intersect ?

1063

What is the life of an sql statement?

1073

What is the need of a partition key?

1025

Does sql view stored data?

1003

explain what is mysql? : Sql dba

1129

What are the advantages of pl sql over sql?

1071

Write a sql query to find the names of employees that begin with ‘a’?

1056

Where is sql database stored?

1037

What is denormalization in a database?

1105

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

1070

What are pl sql procedures?

1077

Does oracle use sql?

987

How do I run a program in pl sql?

1053