Is there a way to get the Database list in the Logon window to be populated with the TNS aliases that are stored on our LDAP server? Our system admins do not distribute the addresses to our local tnsnames.ora file. I have to manually update my tnsnames.ora file so I can have a list of...
I think you need to upgrade to at least the 5.1.6 version of PL/SQL Developer before it works correctly with the Oracle 10g client you are using. Search the PL/SQL Developer forum for "connecting 10g database" for more info.
I'm in need of the same case-insensitive Compare User Objects mentioned above. Was this ever implemented?
I tried a "/i" parameter in the Differences selection within the Preferences window but it did no good. The Compare User Objects window would still report differences but then when I...
No, in my scenario the second user did not have access to the table referenced in the view.
I tried it again where the second user DID have access to the table referenced in the view. It still failed to display the aliased column names.
I tried it another time where the second user had access...
When I look at the source for a view in a schema other than mine it does not show column aliases.
I create a view in one schema like this:
create or replace view test_vw (col1) as
select col2 from test_tb
Now I login as a different user and look at the source of the view and I see...
My sentiments exactly. I use the QBE feature regularly to generate statements that I then incorporate into my code.
Thanks for a great product that makes my job easier!