Interested to Buy Any Domain ? << Click Here >> for more details...
1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?
- 7 Answers
- 19927 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarath
for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Define orabulk and bcp stages?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how do u catch bad rows from OCI stage? And what CLI stands for?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the roundrobin collector?
What is staging variable?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the use of datastage director?
What is the difference between in process and inter process?
Where the datastage stored his repository?
How can we improve the performance in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to implement complex jobs in data stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Define repository tables in datastage?
