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
- 4930 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 |
What is instant client oracle?
if you update view? where we store the data?
Explain the use of show option in imp command.
Explain oracle left join with an example?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
sql command 2 know current database
How to use "for" statements in oracle?
Can multiple columns be used in group by in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
11. Display the client number and name and the client number and name of the person who referred that client.
How to update values in a table in oracle?
Oracle General 
