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
- 6 Answers
- 8725 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to return query output in html format? : Sql dba
What is difference between hql and sql?
How bulk collect improves performance?
What is an exception in PL/SQL? What are the two types of exceptions?
What is an inconsistent dependency?
Is primary key always clustered index?
Where the sql database files are stored?
How do I audit the sql sent to the server?
Is sql pronounced sequel or sql?
How to call shell script from pl sql procedure?
How do you write an index?
How to pipe multiline string to isql?
What is 19 null in sql?
Explain how exception handling is done in advance pl/sql?
What is sql partition?
