• Joining tables without common columns

    How do I join two tables without common columns and display any two columns, all records in a corresponding table?

    ITKE440,540 pointsBadges:
  • How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table

    Learn how to use the V$SEGMENT_STATISTICS view to find the most accessed table in an Oracle database with this query from Oracle expert Brian Peasland.

    oracledba24,045 pointsBadges:
  • Oracle temporary tablespace too large

    One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large.

    oracledba24,045 pointsBadges:
  • Retrieving last row inserted

    I have one table, where in rows getting inserted. I would like to get the last row inserted, while the insertion process continues.

    ITKE440,540 pointsBadges:
  • How can I use INSERT INTO to copy an entire table into another?

    If the tables share the same structure (same number of columns, each matching pair of columns with the same datatype), then the syntax is really simple: Here's how.

    ITKE440,540 pointsBadges:
  • Retrieve last row inserted into table in Oracle

    How can I retrieve the last row inserted into a table? I don't want to have to specify the row number and I can't change the structure of the table.

    ITKE440,540 pointsBadges:
  • Speed up Oracle index creation

    Use this technique for speeding up index creation on large Oracle tables.

    ITKE440,540 pointsBadges:
  • Using inline view to better query joined tables

    One reader asks how to best query data from two joined Oracle tables.

    DanClamage140 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.