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 |
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is a Synonym ?
Explain how you would restore a database using RMAN to Point in Time?
What is a package in oracle?
How to create a stored function in oracle?
Please explain drop constraint oracle?
State and explain about oracle instance?
What would you do with an in-doubt distributed transaction?
Can you tell me how to add new column in existing views?how?How is possible?
List the various oracle database objects?
What to do if dba lost the system password?
How to write date and time literals in oracle?