Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4202 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / 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 |
How to drop a tablespace?
What is the difference between hot backup and cold backup in oracle?
how to find out second largest value in the table
What is transaction control statement and how many types of transaction control statement in Oracle?
What is trigger associated with the timer ?
How can I create database in oracle?
Briefly explain what is literal? Give an example where it can be used?
Why do you use stored procedures and state some of its disadvantages?
Can you use a commit statement within a database trigger?
what are views?
What is a recycle bin in oracle?
What is a table in oracle?
Oracle General 
