Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10226 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
What can sql server reporting services do?
What is pessimistic concurrency control? : Transact sql
What are the benefits of pl/sql packages?
what is the difference between char and varchar data types? : Sql dba
What is dense_rank in sql?
What is dialect in sql?
How can you load microsoft excel data into oracle? : aql loader
Which sql statement is used to delete data from a database?
How to run sql commands in sql*plus?
what is the difference between a having clause and a where clause? : Sql dba
difference between anonymous blocks and sub-programs.
How do I start sql from command line?
What is the difference between delete, truncate and drop command?
Does truncate remove indexes?
How do you copy a table in sql?
