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 are the uses of Database Trigger ?
How to create a new table by selecting rows from another table?
What is clustered table in Oracle?
How do I spool in oracle?
how can we store any pdf file in oracle
How to convert csv to table in oracle?
What is SQL access advisor in Oracle?
State the various uses of dbcc command?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is translate in oracle?
How to convert characters to dates in oracle?
What is oracle sid?
How do I manually uninstall oracle client?
Explain oracle insert into command?
What is raw datatype?