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
- 4318 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many file formats are supported to export data?
How to pass a cursor variable to a procedure?
Explain the characteristics of oracle dba?
How do I manually uninstall oracle client?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are the different types of modules in oracle forms?
How to execute a stored program unit?
11. Display the client number and name and the client number and name of the person who referred that client.
How to start a new transaction in oracle?
What is recovery manager(rman) backup in Oracle?
What is the data pump import utility?
How to use "while" statements in oracle?
What is the difference between substr and instr?
How to connect to a local oracle 10g xe server?
How to write text literals in oracle?
