how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / udaya
SELECT * FROM TABLE_NAME WHERE ROWNUM=1 AND ROWNUM=3 AND
ROENUM=5
| Is This Answer Correct ? | 5 Yes | 32 No |
Post New Answer View All Answers
What does refresh system mean, and what are its distinctive choice?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Define pmcmd command?
How do you load first and last records into target table?
What is an expression transformation in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to generate sequence numbers without using the sequence generator transformation?
Explain the informatica workflow?
wat are deployement groups in informatica, how it will be used for developers
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is meant by query override?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How big was your fact table