1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / surendrababu

Answers were Sorted based on User's Feedback



how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

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

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

Answer / anju hajela

select substr(task_number,-2) from pa_task;

Is This Answer Correct ?    3 Yes 1 No

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

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

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

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

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

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

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is ..

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

Post New Answer

More SQL PLSQL Interview Questions

What is rownum in sql?

0 Answers  

How do I use google cloud in sql?

0 Answers  

What does pl sql developer do?

0 Answers  

Is nosql relational?

0 Answers  

Are null values same as that of zero or a blank space?

0 Answers  




What are the two different parts of the pl/sql packages?

0 Answers  

Enlist the data types that can be used in pl/sql?

0 Answers  

How do I find duplicates in two columns?

0 Answers  

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

What is time based sql injection?

0 Answers  

How do I sort a table in sql?

0 Answers  

Why is pl sql used?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories