how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 22016 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How do you update the records with or without using update strategy?
Mention few power centre client applications with their basic purpose?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What do you understand by a term domain?
Mention few advantages of router transformation over filter transformation.
How to load a Dimension ? and how to load a fact table?
Explain the different kinds of facts.
Is there any target staging area in informatica not staging area
What is intricate mapping?
What do you mean by filter transformation?
what are 3 tech challenges/ common issues you face?
What is rank transformation?
What is the Rank index port in Rank transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the measure objects?
