Oracle EBS Technique Sharing

Friday, October 4, 2019

How to Check First Record and Last Record in Oracle Forms

BEGIN
   IF :SYSTEM.Cursor_Record = '1'
   THEN
      MESSAGE ('At first record.');
   END IF;
END;


BEGIN
   IF :SYSTEM.LAST_RECORD = 'TRUE'
   THEN
      MESSAGE ('At last record.');
   END IF;
END;
Posted by Finch Chen at 8:19 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Forms

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Finch Chen
View my complete profile

Blog Archive

  • ►  2022 (5)
    • ►  September (1)
    • ►  May (1)
    • ►  March (3)
  • ►  2021 (4)
    • ►  April (1)
    • ►  January (3)
  • ►  2020 (12)
    • ►  December (6)
    • ►  November (1)
    • ►  October (2)
    • ►  May (2)
    • ►  January (1)
  • ▼  2019 (13)
    • ►  November (1)
    • ▼  October (4)
      • Oracle Forms - How to create an Alert or Message
      • Oracle Forms - How to avoid duplicated records in ...
      • How to Get Previous Record Value in Oracle Forms
      • How to Check First Record and Last Record in Oracl...
    • ►  September (1)
    • ►  July (3)
    • ►  June (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2018 (35)
    • ►  December (3)
    • ►  November (9)
    • ►  October (2)
    • ►  September (3)
    • ►  August (6)
    • ►  July (4)
    • ►  June (8)
Awesome Inc. theme. Powered by Blogger.