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

How to run create database statement again?

0 Answers  


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  


How to filter out duplications in the returning rows using oracle?

0 Answers  


How remove data files before opening a database?

0 Answers  


what are the advantages of running a database in archive log mode?

0 Answers  






how to make an oracle object

0 Answers  


Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

2 Answers  


Explain an exception and its types?

0 Answers  


What is integrity and what is constraint??Explain with example

0 Answers   Google,


what is integrity constrains?

3 Answers  


How many types of table in Oracle?

0 Answers   MCN Solutions,


What is oracle thin client?

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 (509)
  • 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)