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
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 can I get the number of records affected by a stored procedure?
How can you load microsoft excel data into oracle? : aql loader
What is the difference between joins?
What are the different datatypes available in PL/SQL?
How do you optimize a stored procedure query?
What is cursor and why it is required?
How do you use join?
what is offset-fetch filter in tsql? : Transact sql
What is a table in a database?
Can we create table in function?
What is the difference between nvl function, ifnull function, and isnull function?
How do I view stored procedures?
What kind of join is join?
what is table? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba