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 is a process of pl/sql compiled?

0 Answers  

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

How pl/sql source code can be protected?

3 Answers  

what is d diff between grant,commit,rollback n savepoint

1 Answers  

What is parameter substitution in sql?

0 Answers  

Why use triggers in sql?

0 Answers  

How global cursor can be declare with dynamic trigger ?

0 Answers  

How subquery works in sql?

0 Answers  

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

what is a composite key ? : Sql dba

0 Answers  

Explain the significance of the & and && operators in pl sql.

0 Answers