The rename function does indeed apply only to the window, not to any underlying file or the project items. I have added both options to the list of enhancement requests.

Thank you for the assistance, all!

Hello, any update on this? I also tried to use Active Query Builder and experienced the black background no text on the context menu.

In tab view, if I do a right-click on the tab title with the file name and select "Rename..." an input field to change the name pops up as expected.

But this renaming doesn't affect the actual file nor the entry in the list of project items, if it's stored in a project.

This seems quite confusing to me. It would be quite handy to rename files in the file-system with this function. To rename just the tab/window title only makes sense to me, if any kind of DB object is displayed within the respective tab/window.

This also relates in parts to this thread.

We'll investigate!

Why do you think the current behaviour is incorrect? If i understood it properly - it is perfectly aligned with the visibility rules - if you as userA run the query "select id from test_table" - you'll either get error, because the table is in another schema? For that reason, you can't right click on the unqualified object and expect some context menu appear in the plsql developer, because the object is currently for you not visible.
But, maybe i have not understood your requirement...

Best regards

Maxim

Good morning,
I've got a problem using plsqldoc for the first time: it retrieves the wrong size of the varchar2 fields in an Oracle 19 unicode db.
All other features of PL/SQL Developer are working well but plsqldoc and this makes plsqldoc unusable as documentation tool (at least for me).
Am I wrong something or is this a real bug? It seems it's reading the wrong field in the Oracle dictionary.

I've attached a screenshot showing the difference between plsqldoc and describe command ouputs in PL/SQL Developer.

Best regards
Massimo

Hi,

I'm logged to the database as userA with quite wide privileges, and creating a view for userB using the SQL Window:

Assuming test_table is owned by userB this view could be compiled successfully. But, when right-clicking on the "test_table" (no mater before or after compilation) PL/SQL developer doesn't recognise the test_table as the database object. It only changes if I change the code to:

Could you fix it?

Besides Alt-End (or the associated button on the result set toolbar) there are 2 other methods:

1. Specify a comment directive before the query:

-- records = all
select * from all_objects;

2. Set the "Records per page" preference (Preferences > SQL Window) to "All records". Now all queries will automatically fetch all records.

Regarding your second question - i think the most similar approach would be to put the query 2 (or more if required) times into sql window, run it and then select 2 result set tabs (by Ctrl+LeftClick on the tab) - it brings both tabs in foreground, both result sets can be fetched then separately and positioned by records of interest, both result sets can as well be compared (per menu item "Compare 2 result sets")

Regards

Maxim

Is Alt+End not working for you to fetch last page?

Regards

Maxim

So, title: How to show all results in result set besides spamming Alt + PgDn)


Is there another way besides exporting to excel/csv and then opening it?


Another question would be if I don't have that many columns, could we choose to display multiple pages of a result set, side by side? Like looking at a book, you'd have 1-25 on pg1, 26-50 on pg2.

These handle types are not available for a TOracleSession. You can however set the ExternalSVC proprerty to the service context handle of the FireDAC connection. Note that you need to set ExternalSVC to nil before the FireDAC connection logs off.

Hi Marco,

no, there are no .tmp files left. Today, I lost half of another Workset, but not during windows restart. I closed (on multiple PL/SQL Developers simultaneously running) all Worksets with Close button. Then restarted PC and opened again. Half of windows in workset said "Error reading file" and windows were empty. I saw only half of files in AppData/Roaming/../Worksets/Worksetname .... (and no .tmp files at all). After clicking on empty windows, desktop.0XX files has been created with zero size on FS, oops. See screenshot.

Best Regards,
Stanislav

We would like to share Oracle connection handle between Direct Oracle Access (DOA) component TOracleSession and FireDAC TFDConnection component. We tried several ways but it seems that FireDAC uses it own custom complex "handle" format (see FireDAC.Phys.Oracle.pas):

function TFDPhysOracleConnection.InternalGetCliHandle: Pointer;
begin
if FEnv <> nil then begin
FCliHandles[0] := FEnv.Handle;
FCliHandles[1] := FService.Handle;
FCliHandles[2] := FServer.Handle;
FCliHandles[3] := FSession.Handle;
FCliHandles[4] := TFDPhysOracleTransaction(TransactionObj).FTransaction.Handle;
FCliHandles[5] := FEnv.Error.Handle;
FCliHandles[6] := pOCIHandle(PChar(FEnv.CharsetName));
FCliHandles[7] := pOCIHandle(FEnv.ExplicitCharsetID);
FCliHandles[8] := pOCIHandle(FEnv.ByteSemantic);
Result := @FCliHandles;
end
else
Result := nil;
end;

How can we get all these parts from DOA TOracleSession component? Or maybe we can take some handles from FireDAC TFDConnection and set them in DOA TOracleSession?