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 only NN,but not other
alphabets, if NN is thre means i should display , otherwise
leave that blank or empty Its some urgent
requirement ,thanks in advance
- 2 Answers
- 4680 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reddibasha
SELECT CASE WHEN instr(TASK_NUMBER,'NN')>0 THEN 'NN' ELSE
null END FROM PA_TASKS;
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ajit
SELECT * FROM SAMP;
A
--------
1.1.3NN
1.1.4NN
1.5.1NN
1.3.2NE
SELECT *
FROM SAMP
WHERE A LIKE '%NN';
| Is This Answer Correct ? | 0 Yes | 0 No |
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Can objects of the same Schema reside in different tablespaces.?
Describe varray?
Which Oracle App Is Most Popular One ?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
how will I find the first 5 highest salaried employees in each dept in oracle.
What is a shared pool?
Is there a combination of "like" and "in" in sql?
How do we get field details of a table?
What is the relation of a user account and a schema?
Can multiple columns be used in group by in oracle?
What is the meaning of recursive hints in oracle?
Oracle General 
