0

In SQL Server, we have the functionality of "SELECT TOP xxx ROWS" when we right click a table:

enter image description here

This will generate a SELECT statement with all the columns in selected table written in the new SQL statement. Is there any similar functionality in Oracle SQL Developer?

asked Jul 20, 2018 at 1:23

1 Answer 1

1

There are two parts to this.

  1. RDBMS side
  2. Client side (SQL*Developer)

Client Side

In SQL*Developer, you can drag+drop the table from the Connection to the worksheet in order to get a SELECT statement. A blog on it is here.

If you use the Query Builder, you can drag+drop multiple tables and SQL*Developer will create the JOIN syntax based on defined FK. ThatJeffSmith-Oracle goes over the speed improvements for 18.2 here.

In both cases, the Top n rows clause is not part of the resulting SQL statement.

RDBMS

Oracle database introduced a TOP n ROW clause in 12c.

Example: https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

answered Jul 20, 2018 at 13:07

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.