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 / 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
Explain drop constraint oracle?
How to convert numbers to characters in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to build data dictionary view an new database?
Explain the function of optimizer in oracle?
What is proxy method?
How to enter a new row into a table interactively?
Explain view?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What are named parameters?
How do I uninstall oracle 11g?
What are advantages of dateset in datastage?
How to create a new oracle data file?
What privilege is needed for a user to delete rows from tables in another schema?
What is a trigger and what are its types?