SELECT *, ROW_NUMBER() OVER in Oracle

Try this:

SELECT a.*, ROW_NUMBER() OVER (ORDER BY name ) as row_id FROM schemaName.Zoo a

Here a is alias for table schemaName.Zoo. This will generate all columns from the original table, with row_id column added at the end.

Use SELECT t.*, ROW_NUMBER ... FROM tablename t;