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
- 10561 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pooja
CREATE TABLE B
AS
SELECT *
FROM
(SELECT *
FROM
(SELECT *,ROWNUM R
FROM A)
ORDER BY R DESC)
WHERE R=1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Parameter and variable differences
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Can we change Dynamic to Static or Persistent cache? If so what happens?
tell me 5 session failure in real time how can you solve that in your project?
Which version configuration tool used in ur project?
What do you mean by worklet?
What are the new features of informatica 9.x in developer level?
What is the different lookup cache(s)?
What is the difference between writing a joiner query in ANSI style and THETA style?
Write the program through which the records can be updated?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the different lookup cache(s)?
Explain load alternative records / rows into multiple targets - informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How does a rank transform differ from aggregator transform functions max and min?
