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
- 4769 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 |
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
what is insert all statement in sql
how to retrieve daily sal from emp table in oracle 10g
What is a sub query and what are the different types of subqueries?
What is Database Trigger ?
Explain what are the characteristics of data files?
How to export several tables together?
Difference between pre-select and pre-query
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
When a form is invoked with call_form, Does oracle forms issues a save point ?
How to retrieve data from an cursor to a record?
Oracle General 
