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 / 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 |
what is difference between where clause and having clause?
The join defined by the default data link is an outer join yes or no ?
In which language oracle has been developed?
How to assign data of the deleted row to variables?
What is an oracle transaction?
How to use "startup" command to start default instance?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
Is it possible to insert comments into sql statements return in the data model editor ?
what is the syntax of DELETE command?
What is Row Chaining ?
What is a nvl function? How can it be used?
Difference between open_form and call_form in oracle.