Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4719 Views
- I also Faced
- E-Mail Answers
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
Explain the use of tables option in exp command.
why dont we assign not null constraint as table level constraint.
How to run the anonymous block again?
what are bitmap indexes? How does they work?
does the query needs a hint to access a materialized view?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How do you store pictures in a database?
Explain the different normalization forms?
What do you understand by a database object? Can you list a few of them?
How to view existing locks on the database?
How to convert raw data type into text in oracle? Explain
What is key preserved table?
How to get last row id?
How to add another datafile to a tablespace?
