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
- 4272 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 |
What is autonomous transaction?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is the difference between translate and replace in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Which is better Oracle or MS SQL? Why?
Explain the use of full option in exp command.
Please explain drop constraint oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you extract DDL of a table without using a GUI tool?
Explain integrity constraint?
what is a cartition product?
How to load data from external tables to regular tables?
Oracle General 
