Rawtohex
See stange data in your table? Use rawtohex to make it visible
Update table based on rownum with where clause
We used this query to assign batch id's to records based on rownum. A normal update wouldn't work because we needed a where clause.