Assuming limit is required, the following 41 results were found.
MySQL Oracle equivalentshttps://joellipman.com/articles/else/database/mysql-oracle-equivalents.html
if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM