-
RowIdToRowIdNum Oracle Function
I’m not exactly sure if there’s an existing function in Oracle to convert ROW_ID into a Row_ID Number format. I already know the formula so I created a function. I’ve been using it for a project numerous times so I needed to create this reusable function. CREATE OR REPLACE FUNCTION SH_RowIdToRowIdNum(v_rowid VARCHAR2) RETURN VARCHAR2 IS…
Recent Comments