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
4303 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 an oracle user role?

987

What is a server parameter file in oracle?

1061

What is the data pump export utility?

1087

Explain what are the characteristics of data files?

1086

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2232

What do you mean by merge in oracle?

997

How to create a temporary table in oracle?

1276

How to write numeric literals in oracle?

1190

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2106

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2132

What is an oracle recycle bin?

1012

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

1121

Explain coalesce function?

1210

What do you mean by merge in oracle and how can you merge two tables?

951

What are the differences between primary key and unique key?

1013