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 / 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 |
What are the various oracle database objects?
What is blob data type in oracle?
What are the arithmetic operations?
How many types of tables supported by oracle?
How to omit columns with default values in insert statement in oracle?
Does oracle database need java?
What is an oracle user account?
How to convert character types to numeric types?
Explain view?
How do I know if oracle client is installed on windows?
What are the restrictions on external table columns?
What is literal?