Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4313 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
How to open a cursor variable?
What is ADDM Advisor in Oracle?
How do I uninstall oracle 11g?
List the types of joins used in writing subqueries?
How to view the tablespaces in the current database?
what is the bitmap index?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are various constraints used in SQL?
How to turn on or off recycle bin for the session?
What is the difference between a user and a schema in oracle?
How will you write a query to get a 5th rank student from a table student_report?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Oracle General 
