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 is coalesce function?
What is query image?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
What is a cursor variable?
How to convert times to characters in oracle?
How to assign a table row to a record variable?
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
What is an oracle?
Explain the use of rows option in exp command.
How to revoke create session privilege from a user in oracle?
What is the maximum number of CHECK constraints that can be defined on a column ?