Tuesday, June 14, 2011

To load only requird Rows........

If you want to load only records 3rd, 5th, 10th..

SELECT * FROM (SELECT ROWNUM AS RNO,EMP.* FROM EMP)
WHERE RNO IN (3,5,10)
 







-- Ram

3 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete

  2. Thanks a lot for the wonderful information and it is useful for us.123trainings provides best Informatica online training.tosee free demo classInformatica online training class in india

    ReplyDelete
  3. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete