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.

Answer / anju hajela

select substr(task_number,-2) from pa_task;

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
)

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

Answer / chandu

by using sub_str fuction we can do this

select sub_str(task_number,6) from pa_tasks.

Answer / samiksha

In SQl Sever the query would be:

select substring (reverse(task_number),1, 2) from task

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

how to create a database in oracle?please gve anser with example

1 Answers  

Explain the difference between 'between' & 'and' operators in sql

1 Answers  

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

How do I find duplicates in two columns?

1 Answers  

What is string join?

1 Answers  

Is postgresql a nosql database?

1 Answers  

how to start mysql server? : Sql dba

0 Answers  

What are transaction and its controls?

1 Answers  

Why we use sql profiler?

1 Answers  

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1 Answers   BT,