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
- 4818 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
What are the different types of modules in oracle forms?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is oracle rowcount?
candidate key is subset of super key but not vice-verse explain
Why is oracle database so popular?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain joins in oracle?
What is the difference between pre-select and pre-query?
How to rollback the current transaction in oracle?
How does the on-delete-cascade statement work?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
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 the difference between a user and a schema in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
various types of hints and their usage
