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
- 3915 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's query optimization and without use of IN AND Exist can we get another way data from query
What are the uses of Rollback Segment ?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
How to create a new oracle data file?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is recovery manager(rman) backup in Oracle?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
After update how do u know how many records got updated
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the string concatenation operator in oracle?
What is meant by joins?
Oracle General 
