how to get required data from oracle source is like this ram_05_seetha lax

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 / koti

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

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy..

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

Post New Answer

More Oracle General Interview Questions

How to assign data of the deleted row to variables?

0 Answers

What are various constraints used in SQL?

1 Answers Polaris,

WHT ARE THE AGGREATE FUNCTIONS?

7 Answers GEITC, TCS,

what is grid in Oracle 10g...

1 Answers

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers

hai, when to use char and varchar2....?

2 Answers

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers

How many types of table in Oracle?

0 Answers MCN Solutions,

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 Answers

Explain the use of owner option in exp command.

0 Answers

difference between truncate and delete ,drop?

3 Answers

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

For more Oracle General Interview Questions Click Here