how to get required data from oracle
source is like this
ram_05_seetha
lax_05_viswa
bamr05frummy
run_01_away
sw_sas_trim
i want my target data like
ram_05_seetha
lax_05_viswa
to get data using %_05_%
but it will give
ram_05_seetha
lax_05_viswa
bamr05frummy
how can i get my target data?
Answer Posted / mukesh
select source_field from
(select rownum rn,source_field from source_data
) where rn In(1,2)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the exact use of Collections?
How to change user password in oracle?
What is a cognitive schema?
How to return top 5 rows in oracle?
How to put more than 1000 values into an oracle in clause?
What is a select query statement in oracle?
Is insert autocommit in oracle?
What is oracle and what are its different editions?
How to write a query with a left outer join in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What language does oracle use?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the tools for Oracle ?
Give the various exception types.
When do we use group by clause in a sql query?