Tag: oracle

65 votes
14 answers
3.1K views
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this:

avatar
Vi
0 1 0 9
asked 07 September, 2021
50 votes
24 answers
1.7K views
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

avatar
Freida
0 1 0 9
asked 07 September, 2021