Recent content by wardy

Think you'll need to speak to your DBA's. Most production environments dont allow code to be seen. You might be able to see the specs but not the actual code.

Ran both machines with debug and they both have the same result for NLS 26/04/2018 08:38:02 TOracleQuery $03A6C040 Start Query.Execute SQL = select * from nls_database_parameters where parameter like 'NLS%CHARACTERSET' 26/04/2018 08:38:02 TOracleQuery $03A6C040 End (2...

Thanks for the reply however i dont think its correct. Help > Oracle info is below from two different machines to the same database This one works Character Sets Character size: 1 byte(s) CharSetID: 31 NCharSetID: 2000 Unicode Support: True NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1...

Hi all, Can someone tell me where this setting is amended? On some clients we have it set to 0 and others its set to 2000. We are seeing issues with pound signs being converted / displayed as a hash sign and this setting appears to be the only thing that is different Cheers

Hi, Never even thought about using query builder. Always start with a new SQL window. Cheers Mark

Is there a possiblilty of incorporating an auto table join based on the foriegn keys and columns on a table. The way i see it could work is when you have a table is your from statement could you highlight and right click on the table name and then get a list of tables that are joined to / from...

Thanks, i will take a look at your site. I have downloaded one of the plugins on this site and that will suffice for the moment

Hi new to the forum but I have been using PLSQLD for a couple of years and think its great. I have a couple of questions or maybe even an enhancement. Can anyone provide any example code for a plugin created via Visual basic. I can code a little in VB. The reason I ask is a I would like to...