select source_field from (select rownum rn,source_field from source

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?

Question Posted / mukesh

1 Answers
4295 Views
Infosys, I also Faced
E-Mail Answers

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

What is index in Oracle?

1073

What is dynamic proxy?

1005

What are the types of trigger in oracle?

979

Explain alias?

1147

What is the scope of a local variable?

1067

How many types of cluster table in Oracle?

1034

How to view existing locks on the database?

1053

How do I limit the number of rows returned by an oracle query after ordering?

1168

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1078

What is index-organized table in Oracle?

1069

What are the advantages of oracle 12c?

1180

How to rebuild an index in oracle?

1026

How to get the Installed Oracle Version Information ?

1123

Explain the types of exception?

1143