how do u get the first record from 50,000 records ?
Answer Posted / rv
select @ from <tbl> where rownum>2; im right ?
other wise mail to me rayallarv@gamil.com
| Is This Answer Correct ? | 2 Yes | 24 No |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Implementation methodology
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to convert multiple rows to single row (multiple columns) in informatica
What are multi-group transformations?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What does reusable transformation mean?
Define mapplet?
Write the program through which the records can be updated?
Performance tuning( what you did in performance tuning)
What is meant by active and passive transformation?
What are mapplets? How is it different from a Reusable Transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How do we call shell scripts from informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa