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?
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
What is an oracle user role?
What is a server parameter file in oracle?
What is the data pump export utility?
Explain what are the characteristics of data files?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What do you mean by merge in oracle?
How to create a temporary table in oracle?
How to write numeric literals in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
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.
What is an oracle recycle bin?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Explain coalesce function?
What do you mean by merge in oracle and how can you merge two tables?
What are the differences between primary key and unique key?