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
- 10399 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 is the reports view in oracle sql developer?
What is sqlexception in java?
how to analyze tables with 'mysqlcheck'? : Sql dba
Can a commit statement be executed as part of a trigger?
What are string functions in sql?
Which is the correct statement about truncate and delete?
Write an sql query to select all records from the table?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
what are all types of user defined functions? : Sql dba
what is transaction? : Sql dba
What are the triggers associated with image items?
what is a constraint? Tell me about its various levels. : Sql dba
How do you declare a constant?
How many clustered indexes can be created on a table?
What is the difference between inner join and left join?
