select substr(task_number,-2) from pa

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 / anju hajela

6 Answers
10217 Views
I also Faced
E-Mail Answers

Answer Posted / anju hajela

select substr(task_number,-2) from pa_task;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do we need to check in database testing?

964

What is out parameter used for eventhough return statement can also be used in pl/sql?

1014

Is subquery faster than join?

951

What is the difference between syntax error and runtime error?

1065

Can we use rowid as primary key?

941

What is sqlca in powerbuilder?

953

Explain the difference in execution of triggers and stored procedures?

966

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

970

Define join and name different types of joins?

957

What is the advantage of nosql?

994

How to use boolean type in select statement?

993

what are the features and advantages of object-oriented programming? : Sql dba

951

What are different sql data types?

954

What is the difference between instead of trigger and after trigger?

948

How do you take the union of two tables in sql?

933