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
Is the After report trigger fired if the report execution fails ?
What is the dynamic sql in oracle?
What do you mean by merge in oracle?
What privilege is needed for a user to create tables in oracle?
what is the difference between restoring and recovering?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between Delete, Truncate and Drop in Oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is a nested table and how is it different from a normal table?
How to define an oracle sub procedure?
Explain the use of file option in exp command.
What are set operators?
What is truncate oracle?
How to start your 10g xe server from command line?
What is a lookup table in oracle?