One common use of rowid is to workaround the restriction of fetching across commits when using the FOR UPDATE and CURRENT OF clause. This is described in detail in the PL/SQL documentation.