Danny Torres
Follow / 14 Sep 2016 at 5:03pm / Toad for Oracle
Latest post by on 28 Nov 2017 at 6:27pm

How to get the most out of this forum – Best practices for what information...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post. - Product,...

The better a problem is described, the better the assistance tends to be.
In order to better assist with your issue at hand, please include the following information in your initial post.

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below)


How to create Support Bundles

The support bundle window provides information about several aspects of your Oracle and Toad setups. In addition, the Support Bundle lets you easily report problems to our peer-to-peer mailing lists or directly to Support.
If Toad itself fails, the Error dialog box displays. This type of an error creates a log, saved as toad.elf. This Eureka LogFile (.elf) contains both the application information and the callstack of the error created, and can be very helpful to Support in solving issues you are having with Toad.

To create a support bundle:

Select Help | Support Bundle.

Review the following for additional information:

Email Quest Support

This opens the "Email Quest Support" window with instructions and links to contact Support, and to open a new case or service request.

Quest Web Support

This opens Quest Software's award-winning Support portal in your default browser, with access to Licensing Assistance, the searchable Knowledge Base, product downloads and more.

Attach TOAD.INI (or SQL Tuning Support details) to emails

If selected, this attaches the details to any email sent through the support bundle, whether it is to the peer-to-peer Toad list or to Support.

 *Note: Please refrain from including private data in your posts. Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you. 

Release Information: 

Here are some key links: 

  • Link to Documentation:

https://support.quest.com/toad-for-oracle        

(Release Notes includes latest release enhancements; Installation Guide includes pre-requisites; Getting Started includes product features) 

  • Link to Downloads (existing customers):

https://support.quest.com/toad-for-oracle/download-new-releases 

  • Link to Trial (new customers):

https://www.quest.com/products/toad-for-oracle/software-downloads.aspx

  • Knowledge Base Articles:

https://support.quest.com/toad-for-oracle/kb 

The Support Knowledge Base includes Videos, Tutorials, and other information intended to help users.

Feel free to browse the knowledge base articles. Remember to sign in to your account to view.

2841 3 / Create an account to join the discussion.
Jon.Lin
Follow / 8 Sep 2016 at 10:08pm / Toad for Oracle
Latest post by on 26 Jun 2017 at 1:55pm

Latest Release Information

Expand content
Here you can find information on our latest release, from features to downloads & documentation: https://support.quest.com/spotlight-on-oracle

Here you can find information on our latest release, from features to downloads & documentation:

   https://support.quest.com/spotlight-on-oracle

2262 2 / Create an account to join the discussion.
Mara_B
Follow / 17 Jan 2018 at 8:49pm / Toad for Oracle
Latest post by on 18 Jan 2018 at 8:55pm

How do I get multiple data records from a query using variables

Expand content
I am new to TOAD and Oracle. This is SQL code, How do I do this in TOAD to get the result set and without the popup window which ask for a value input. This process will run daily to extract data, so flexibility...

I am new to TOAD and  Oracle.   This is SQL code, How do I do this in TOAD to get  the result set and without the popup window which ask for a value input.  This process will run daily to extract data, so flexibility is needed with the dates. 

DECLARE @tempdate datetime

 

SET @tempdate = (SELECT case when DATEPART(dw,GETDATE()) = 2 then dateadd(dd,-3,getdate() )

                           else dateadd(dd,-1,getdate() )

                           End

                    )

 

Select * from ABC.TRAN where ENTRYDATE = @tempdate

100 3 / Create an account to join the discussion.
jennifer_22301
Follow / 18 Jan 2018 at 6:13pm / Toad for Oracle
Latest post by on 18 Jan 2018 at 7:15pm

View Script Formatting - Toad for Oracle 12.11.0.95

Expand content
Have searched for answers on this forum, unable to find the specific answer. Apologies if I missed it. Issue: Using the Describe Objects feature (clicking F4 on view name) and Script (with Views >...

Have searched for answers on this forum, unable to find the specific answer.  Apologies if I missed it.

Issue: Using the Describe Objects feature (clicking F4 on view name) and Script (with Views > Format UNCHECKED), results in:

Create or replace view X_view 

(column_1,column_2,column_3)

as

select

          -- header comment1

          -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

What I need: 

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

        select

                   -- header comment1

                   -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

If Format is CHECKED then the column names are aligned as desired, but the content of the select statement are skewed all over the place (i.e., the comments, and many of the lines are split into separate lines).

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

       select

                                                                                                                               -- header comment1

                                                                                                         -- header comment2

  x1

               column_1,

  x1

               column_2,

  x1

               column_3

from table;

In Toad for Oracle 12.10.0.30, I was able to leave the Format option CHECKED, and the format came out formatted like this:

Create or replace view X_view 

(column_1,

 column_2,

 column_3)

as

        select

                   -- header comment1

                   -- header comment2

  x1 column_1,

  x1 column_2,

  x1 column_3

from table;

Any hints are appreciated.  It is very difficult to read the views in my current Toad version. :(  

46 1 / Create an account to join the discussion.
Dennis Paulus

Beta Released (13.0.0.30)

Expand content
Beta Notes Rebuild Table Rebuild Table now looks nicer.�� Generate Database Script Generate Database Script now looks nicer, with a similar look and feel to Compare Schemas, Generate Schema Script, and...

 

Beta Notes

Rebuild Table

Rebuild Table now looks nicer.��

Generate Database Script

Generate Database Script now looks nicer, with a similar look and feel to Compare Schemas, Generate Schema Script, and Compare Databases.

Formatting/Parsing (QP5)

Parser

  • Fix (QP 2766) : Packages: Chunking fixed when the keyword AS is used in a CAST function.
  • New (QP 2755) : Support for SET SQLFORMAT.
  • New (QP 2758) : Support for custom analytic functions in PIVOT clause.
  • New (QP 2755) : Several small fixes and (undocumented) additions in JSON_QUERY, JSON_VALUE, JSON_TABLE and ALTER SESSION.

Formatter

  • New (QP 138) : Formatter now uses less memory during formatting large lumps of SQL text.
  • Fix (QP 2768) : Formatter fails to align values in VALUE clause.

Code Analysis

  • New (QP 2285) : Rule 6709 ("ROWNUM found in a WHERE clause.")
  • New (QP 2783) : Rule 2141 ("Make sure the given Schema Prefix name exists for all objects.")
  • New (QP 2783) : Rule 2142 ("Table names should be under N characters.")
  • New (QP 2783) : Rule 2143 ("When creating an index or a table then specific tablespaces should be used.")
  • New (QP 2783) : Rule 2144 ("When creating a table then a primary key should be created.")
  • New (QP 2783) : Rule 2145 ("Avoid using the listed data types.")
  • Fix (QP 2735) : Rule 2746 ("A CASE statement should have an ELSE clause") Rule type, category and severity were missing, causing the rule not to appear in the Toad rule universe.
  • Fix (QP 2735) : Rule 6748 ("Consider writing IF THEN CONTINUE as CONTINUE WHEN.") Rule type, category and severity were missing, causing the rule not to appear in the Toad rule universe.

19 0 / Create an account to join the discussion.