Interested to Buy Any Domain ? << Click Here >> for more details...
i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
- 7 Answers
- 10862 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
by using with clause
WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What is the use of target designer?
What is exclusive and normal mode for repository services?
Explain target update override in informatica
Target increases every day even though no new record was inserted
How to create the source and target database connections in server manager?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the format of informatica objects in a repository?
What is rank transform?
How many ways a relational source definition can be updated and what are they?
How to update or delete the rows in a target, which do not have key fields?
What if the source is a flat-file?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the status code in stored procedure transformation?
What are the types of caches in lookup? Explain them.
