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
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 |
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
Will you be able to store pictures in the database?explain.
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How to start your 10g xe server?
What is varray?
which statement is running fastly ie insert or delete?
What is SQL Tuning Advisor in Oracle?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
master table and child table performances and comparisons in Oracle ?
What happens if you lost a data file?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
primary key is foreign key for the same table?