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
- 6 Answers
- 9457 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
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Why select is used in sql?
Can we insert in sql function?
Explain the insert into statements in sql?
Is pl sql and postgresql same?
Mention what are different methods to trace the pl/sql code?
What do you mean by table in sql?
What programs use sql?
What are the various levels of constraints?
What is autocommit sql?
What is substitution variable?
How do you bind variables in pl sql?
how to rename an existing table in mysql? : Sql dba
What are stuff and replace function?
Can we rename a column in the output of sql query?
