Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10227 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
by using sub_str fuction we can do this
select sub_str(task_number,6) from pa_tasks.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain scalar functions in sql?
Can primary key be changed?
What are all the different normalizations?
how to rename an existing table in mysql? : Sql dba
How to select unique records from a table?
What is cursor status?
What are the types of variables use in pl sql?
When to use inner join and left join?
What is sql in oracle?
What is the use of primary key?
How to check if a column is nullable before setting to nullable?
Can we edit a view in sql?
Is a view faster than a stored procedure?
What is the difference between left and left outer join?
How do I start sql profiler?
