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
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
What are different joins used in sql?
What is the difference between left outer join and left join?
What are the sql commands?
How does sql profiler work?
what is msql? : Sql dba
Is sql low level language?
Why do we use cursors?
Why is sharding used?
What is the difference between unique and primary key constraints?
How global cursor can be declare with dynamic trigger ?
What is nvarchar in sql?
Can you have more than one trigger on a table?
Why do we use procedures?
What is %type in pl sql?
Which is better varchar or nvarchar?