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
- 3907 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is connection pooling in oracle?
How to use fetch statement in a loop?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is a cursor in oracle?
What is a sub query? Describe its types?
How can I combine multiple rows into a comma-delimited list in oracle?
How do we display rows from the table without duplicates?
What is meant by recursive hints in oracle?
How to use values from other tables in update statements using oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a cognitive schema?
Explain the use of rows option in imp command.
Differentiate between post-database commit and post-form commit?
how to make an oracle object
How to use group functions in the select clause using oracle?
