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
4273 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

How to bring a tablespace offline?

1046

Explain the use of full option in exp command.

1090

How to update values on multiple rows in oracle?

1019

How to define a sub function?

1111

What is difference between cartesian join and cross join?

1071

How to load data through external tables?

1120

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1028

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2166

What is an oracle function?

1133

What is truncate oracle?

960

How can you use check constraints for self referential integrity?

948

Can you drop an index associated with a unique or primary key constraint?

1000

What is the difference between translate and replace in oracle?

1148

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1081

How to retrieve data from an explicit cursor?

1039