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
How to create a new oracle data file?
What is control file used for?
How to loop through data rows in the implicit cursor?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the use of record option in exp command.
How to convert csv to table in oracle?
What is a initialization parameter file in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is the sql query to concatenate column values from multiple rows in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a subquery?
What is oracle in java?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is null value in oracle?
How to pass a cursor variable to a procedure?