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 |
How to do paging with oracle?
Explain the difference between sql and oracle?
can we insert any row to dual table if i got the permission from DBA
How do I escape a reserved word in oracle?
How to declare a local variable?
What is index in Oracle?
What is the purpose of save points in oracle database?
what is the syntax of DROP command?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
How do we get field details of a table?
How to Identify the previously inserted/updated records in already populated table.
How many types of auditing in Oracle?