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 |
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
without using count(*) and rownum how can we count total record in a table
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
How to turn on or off recycle bin for the session?
What is memory advisor in Oracle?
How to find the duplicate rows count from employees table in oracle?
What is a data segment ?
Explain the use of full option in exp command.
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What are the Limitations of a CHECK Constraint ?
what is the syntax of DELETE command?