UPGRADE (v3.8)TRIAL (v3.8)
Toad Intelligence Central 2.7
FREE Toad Data Point Viewer
These people make Toad Data Point great and have the most points for this month!
Toad™ Data Point is a multi-platform database query tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare it all, and produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:
Use these links below to learn more about the most popular Toad Data Point topics!
We’re seeing many organizations move toward agile methodologies. But with the transition from manual change-and-release management to an automated approach of continuous integration comes new challenges ...
Are you struggling to manage an increasingly complex database environment? If so, you’re not alone. Research shows that data growth is doubling every 18 months. And it’s not...
I have a query that I would like to automatically save to a fixed width text file, although the columns can have different widths, from Toad Data Point 3.2.
Here are the different methods I've tried:
- Tools\Export\Export Wizard allows me to build and save an export template but doesn't have the option for custom column widths
- Right clicking on the Result Set of the query I just executed and selecting Export\Export Wizard does give the option to enter custom column widths but it doesn't give me the option to save the export template.
- From the Report designer I can export the document as a .txt file manually. It's in the proper format because I lpad & rpad everything to the proper widths. But when I go to automate the .tdr I lose the option of exporting it as a . txt file.
Thanks for your help!
I'm facing a problem in connecting to oracle 10g with a password containing some special characters (double quote and dollar):
I can connect correctly using sqlplus and sql developper, but when I try with my toad data point I get the following error:
System.ArgumentExceptionInvalid character in non-quoted parameter valueStack Trace: at Devart.Common.r.a(Hashtable A_0) at Devart.Common.r..ctor(String A_0, Hashtable A_1, Boolean A_2) at Devart.Data.Oracle.ce..ctor(String A_0) at Devart.Data.Oracle.au.a(String A_0, r A_1) at Devart.Common.DbConnectionFactory.a(String A_0, r& A_1) at Devart.Common.DbConnectionBase.set_ConnectionString(String value) at Quest.Toad.Db.ConnectionProxy.Implementation.ConnectionImplementation..ctor(String fullType, String connectionString) at Quest.Toad.Db.ConnectionProxy.ProxyConnection.ActualCreateConnection(Object parameters)
I tried escaping with backslash, double backslash, surrounding with apexes but nothing works.
Thanks in advance.
Getting Error: [Teradata Database]  'š' ('A0'X) is not a valid Teradata SQL token. while executing code;
select top 10 * from SVC_BASE.S_EVT_ACT_X where ATTRIB_43 ='87901041270'