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?



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

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  


The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,


How to use values from other tables in update statements using oracle?

0 Answers  


What is oracle thin client?

0 Answers  


Respected sir, Please send me technical questions related to oracle apps..

0 Answers  






What is oracle latest version?

0 Answers  


types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  


What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,


Why do you use stored procedures and state some of its disadvantages?

0 Answers  


What do you mean by redo log file mirroring?

0 Answers  


How to sort output in descending order in oracle?

0 Answers  


What is the maximum number of triggers that can be applied to a single table?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)