Recent content by Lukasz Indeka

  1. L

    Updater does not see newest version

    Updater haven't found the 16.0.6.2170 version. I spotted it on the forum.
  2. L

    Alternate row color in the Excel exports

    I have a feature request: When I add -- AltRowColor = 333333 above the query, then it is shown only in PL/SQL Developer. Would be great if it would be moved to the Excel export as well.
  3. L

    Accessing objects from another schema

    You're right. My idea was that if I prepend test_view with the userB schema name, then PL/SQL Developer should see objects like I was logged in with userB privileges. When I thought about it again, this is a very bad idea.
  4. L

    Problems with compilation of a large view

    Hi, What's the difference between: 1. opening the view code in the SQL Window and pressing F8 button vs. opening the Compile Invalid Objects window and either 2. pressing F8 (let's ignore other invalid objects for now) or 3. selecting the invalid object and pressing Recompile from the dropdown...
  5. L

    Accessing objects from another schema

    Hi, I'm logged to the database as userA with quite wide privileges, and creating a view for userB using the SQL Window: create or replace view userB.test_view as select id from test_table; Assuming test_table is owned by userB this view could be compiled successfully. But, when...
  6. L

    Automated export to Excel from set of DBs

    Maybe I could create a small plug-in running the queries set given by the command line parameter and then export the result set using a popup menu hook? All called automatically, after the connection is established. Would it be possible?
  7. L

    Automated export to Excel from set of DBs

    Is it possible to run the set of queries and have automatically an Excel file generated from all result sets for couple databases? My use case: Let's say I have a dummy SQL file with the following content: -- Excel = c:\Exports\%yyyy%_%mm%_%dd%\%dbname%_%yyyy%_%mm%_%dd%_-_%hh%_%mi%.xlsx --...
  8. L

    Table structure view enhancement

    I'm still thinking about this and having more ideas. Please add sorting also on the rest of tabs and columns of the grids (except General tab, of course). And, possibly, filtering by all the Name columns and additionally: Columns on the Keys tab, Columns on the Indexes tab, Grantee and...
  9. L

    Feature request: Mark not known object in the SQL Window

    When there is a typo in my schema or table name and I call Code Assist after the dot, nothing happens. It looks like Code Assistant just doesn't work. It always takes me a couple seconds to figure out what's wrong. Could you add either some underscore under the unknown object name or just Code...
  10. L

    Table structure view enhancement

    One more request for the same window. Could it be possible to add a deferred data retrieval option? What I mean: when I have very wide table, then the opening of the window is very slow (especially for remote connection). I would prefer to have this window opened after 1 second on the General...
  11. L

    Problem when dark mode is on

    Main menu --> Tools --> Sessions --> Define session Queries... are wrongly skinned, when using color theme mode Auto (Windows set to Dark style). See attachments.
  12. L

    Table structure view enhancement

    Thanks! I haven't used this option yet.
  13. L

    Table structure view enhancement

    Could it be possible to add sorting possibility on the Columns tab of the table structure window? Reasoning: when I have a very wide table (with many columns) it's often hard to find specific column. I have to select * from selected_table then switch to the Single Record View and set proper...
  14. L

    SQL tab for Multi-query Excel export

    When I export results of a couple queries to Excel, then on the last (SQL) sheet, SQL queries have no semicolon. Could you, please, add it? It would be much easier to reuse the code.
  15. L

    Problem with autocomplete of overloaded procedures

    Mouse is an evil. I use keyboard. I'm selecting overload by pressing Alt + Left/Right arrow when Code Assistant is open. What I've changed for sure between 15.0 and 16.0 is disabling automatic Code Assistant pop-up.
Back
Top