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
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 pragma autonomous transaction in oracle?
How to export your connection information to a file?
What are the numeric comparison operations?
How to return top 5 rows in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Is oracle an open source?
How to retrieve values from data fields in record variables?
Explain how are indexes update?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How do I call oracle stored procedures that take no parameters?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
why dont we assign not null constraint as table level constraint.
What suggestions do you have to reduce the network traffic?
What is the quickest way to export a table to a flat file?
What is Reduced List of Values?