ORACLE SQL:Get all integers between two numbers

by

This trick with Oracle’s DUAL table also works:

SQL> select n from
  2  ( select rownum n from dual connect by level <= 10)
  3  where n >= 3;

         N
----------
         3
         4
         5
         6
         7
         8
         9
        10

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. Select First Row of Every Group in sql [duplicate]
  4. Oracle: how to UPSERT (update or insert into a table?)
  5. Get top results for each group (in Oracle)
  6. Comparing Dates in Oracle SQL
  7. Oracle Differences between NVL and Coalesce
  8. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  9. ORA-12560: TNS:protocol adaptor error
  10. SQL – How to store and navigate hierarchies?
  11. GROUP BY / aggregate function confusion in SQL
  12. Oracle “(+)” Operator
  13. How do you create a temporary table in an Oracle database?
  14. What exactly do quotation marks around the table name do?
  15. How can I get column names from a table in Oracle?
  16. How to store only time; not date and time?
  17. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  18. How to check the maximum number of allowed connections to an Oracle database?
  19. Select without a FROM clause in Oracle
  20. Is there any way to flush output from PL/SQL in Oracle?
  21. PLSQL Insert into with subquery and returning clause
  22. SELECT from table with Varying IN list in WHERE clause
  23. Does Oracle use short-circuit evaluation?
  24. Advice Using Pivot Table in Oracle
  25. How to use a dynamic parameter in a IN clause of a JPA named query?
  26. Search an Oracle database for tables with specific column names?
  27. ORA-01861: literal does not match format string
  28. Query a Table’s Foreign Key relationships
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment