Row Numbers / Table Data

[DirkHamburg]

Hello!

in my company we are starting working with the PL/SQL Developer and have two questions.
Searching the tool's help and the forum didn't give a solution, so I hope that You can help...

1. Is there a way to get row numbers in the SQL Window? This would be very helpful.

2. Is there a way to find duplicate rows in a table? In the Quest TOAD there is a Menu-Item "Table Data Duplicates", where I can find duplicates of a table, concerning all or a group of table columns. Does the PL/SQL Developer have something like that?

Thank You for Your help!

Greetings from Hamburg,

Dirk Schroeder

 

[Marco Kalter]

1. Is there a way to get row numbers in the SQL Window? This would be very helpful.

I assume you mean in the SQL Editor? This is currently not possible.

2. Is there a way to find duplicate rows in a table? In the Quest TOAD there is a Menu-Item "Table Data Duplicates", where I can find duplicates of a table, concerning all or a group of table columns. Does the PL/SQL Developer have something like that?

No, there is currently no function for this. You can only create a SQL statement to find these records.