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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anju hajela
select substr(task_number,-2) from pa_task;
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vinay singh
select * from PA_TASKS pp
where pp.TASK_NUMBER in
(select QQ.TASK_NUMBER from PA_TASKS QQ
where length(trim(translate
(QQ.TASK_NUMBER,'0123456789',' '))) > 0
)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sumathy
Create table PA_TASKS ( TASK_NUMBER nvarchar (30))
Insert into PA_TASKS values ('1.1.3NN')
Insert into PA_TASKS values ('1.1.4NN')
Insert into PA_TASKS values ('1.5.1NN')
Insert into PA_TASKS values ('1.3.2NE')
Insert into PA_TASKS values ('1.5NN')
Insert into PA_TASKS values ('1NN')
Insert into PA_TASKS values ('1.2NE')
Insert into PA_TASKS values ('1CE')
Select reverse( substring(reverse (TASK_NUMBER),1,2)) from
PA_TASKS
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandu
by using sub_str fuction we can do this
select sub_str(task_number,6) from pa_tasks.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / samiksha
In SQl Sever the query would be:
select substring (reverse(task_number),1, 2) from task
Is This Answer Correct ? | 1 Yes | 2 No |
In packages the source code is compiled into p code ? how do we describe the p code
Can there be 2 primary keys in a table?
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
cursor types? explain with example programs?
which types of join is used in sql widely? : Sql dba
What is difference between pls_integer and integer?
What is pl sql in oracle?
Difference between views and materialized views?
Can we update views in sql?
how to use like conditions? : Sql dba
how to use 'mysql' to run sql statements? : Sql dba
What is normalization and types of normalization?
22 Answers Etisbew, F-TEC, Microsoft, TechProcess,