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
- 3925 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
Is there a function to split a string in plsql?
What is the difference between sharding and replication?
How to do a full database export?
What is save point in oracle database?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the differences between char and nchar in oracle?
Will you be able to store pictures in the database?
What is the difference between 10g OEM and 11g OEM?
How to invoke the original export import utilities?
How to set up autotrace for a user account?
How to find out what oracle odbc drivers are installed?
What are ddl statements in oracle?
What is SQL access advisor in Oracle?
What is meant by a deadlock situation?
