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


Please Help Members By Posting Answers For Below Questions

How to find the duplicate rows count from employees table in oracle?

522


What are the attributes of the cursor?

529


What is the recommended interval at which to run statspack snapshots, and why?

2411


What is data type in oracle?

535


How to use windows user to connect to the server?

510






Can you have more than one content canvas view attached with a window ?

1794


Explain integrity constraints?

636


What is merge statement used for?

542


What is the difference between sharding and partitioning?

481


How to concatenate two text values in oracle?

572


What are the uses of a database trigger?

504


How to assign query results to variables?

572


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2864


How to Truncate Table in Oracle

631


What is hash cluster in oracle?

578