Stack Overflow
Stack Overflow

Questions tagged [toad]

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

This tag should be used for questions regarding how to use Toad software.

1263 questions
-1
votes
1 answer

dbms_output.put_line shows variable value but does not save to database

I am trying to save a value in a table after removing an & in the input variable. When I print the value of the variable in dbms_ouput.put_line I get the output. but when I save the value of the variable to database, nothing is updated. Code below…
Sarwar
  • 31
  • 1
  • 4
-1
votes
2 answers

Not a GROUP BY Expression & aggregate functions

I was wondering why, for this query that I have right here, why I have to use the MAX() aggregate function for the case statements, and not just jump directly into the case…
JamesP
  • 195
  • 1
  • 3
  • 17
-1
votes
3 answers

I am stuck in a situation while creating SQL for following scenario

I have tried using Case-End but nothing worked. Diff types of phone number are : Home Cell Main OTPR Busn
Anit Singh
  • 159
  • 1
  • 1
  • 8
-1
votes
1 answer

Cascade copy in oracle

I would like to make a cascade copy. I have a MODEL and the specification of this MODEL is stored in 4 tables and one MODEL is identificated by MODEL_ID in the tables. The MODEL_ID of the MODEL is primary key and the MODEL_ID is increased one by…
user2342549
  • 45
  • 1
  • 2
  • 9
-1
votes
1 answer

Squirrel SQL Error with Oracle Reserved Words

Been scratching my head for a while with what should be a simple Update Statement using the Java Based Squirrel SQL Client, version 3.4.0 (Note: This works fine in TOAD for Oracle, but long term I am expected to use Squirrel. The query is: UPDATE…
DavidBirkin
  • 28
  • 6
-1
votes
3 answers

In Toad for Oracle using SQL Query how do I change data output to representative characters

I made a query and my output has columA. In column A the potential data is Dog or Cat, if the Output is: Dog then I want it to be shown as B Cat I want it to be shown as T. How can I do this in Toad for Oracle using a SQL Query?
user1876303
  • 1
  • 1
-1
votes
1 answer

oracle table is not listing in the Toad schema browser for the particular schema

I have a table named TableA in oracle 11g database, i could able to select this table by using the particular user id in toad, but i dont find this table in the toad schema browser for that schema in the toad. please advice me on why i couldnt able…
senthil
  • 65
  • 4
  • 15
-1
votes
4 answers

SQL and toad

I have a select query that fetches some values based on user input, for EG :- SELECT company, accounts from testdrive WHERE company LIKE '&Company', accounts = '&Account' order by company desc On running this in Toad, the user is prompted for…
am707
-2
votes
3 answers

SQL: Select only one row with same value and filters

I need to do some Database sorting and filtering: my DB looks like this: ID No Status 32 98765 0 32 0 2 70 43210 0 70 0 2 The final output needs to be: ID No Status 32 98765 0 70 43210 0 If an ID with the same value…
Mr.ED
  • 1
  • 1
-2
votes
1 answer

Plsql date function delete data in table

Good morning In one table. I have LOADDATETIME column name- DATE datatype.. And value will be in the "13/06/2022 18:46:23" I need to delete rows in the table by using Loaddatetime column.. How can I delete. Could u pls tell anyone
Sanjay Reddy
  • 1
-2
votes
1 answer

How do I change the hyperlink display text to reflect the result from another column in SQL?

Can anyone tell me how I can get my URL text to show up as the the "IMAGE NAME" in my query? I am using Toad Data Point SQL Builder and this is what I have so far SELECT ast.location, ast.assetnum, ast.description, own.alnvalue AS…
SS0309
  • 3
  • 2
-2
votes
2 answers

How to add two tables having sum of amounts on the basis of year in SQL(toad)?

First Table : SELECT A.BU,A.PROJECT,SUM(A.BUDGET_AMOUNT),SUBSTR(A.BUDGET_PERIOD,3,2) FROM BUDGET_SUMMARY A GROUP BY A.BU,A.PROJECT,SUBSTR(A.BUDGET_PERIOD,3,2) And the second table: SELECT…
Key_girl
  • 13
  • 2
-2
votes
1 answer

getting error when I start toad application

I am getting this problem when I start TOAD. The following error has occurred: Cannot open file D:\DBASE\TOAD\TEMPS\PLSQLSCR.TXT How can I resolve this problem? If anyone has an idea please share it with me.
praveen kumar
  • 1
  • 3
-2
votes
1 answer

Cannot see tables/views in Toad Scheme browser

Upon Toad, I can query tables, but can't use Toad's schema browser to see, what can I do to fix it?
DinaJ
  • 1
  • 2
-2
votes
1 answer

oracle query if else

How the below query handle in oracle database, I am trying in Toad Query1 - SELECT T_BASIS_ACCESS_ID FROM ECKERNEL_MCA.T_BASIS_ACCESS WHERE ROLE_ID LIKE 'MCA.GFS.LEAD' Query2 - SELECT OBJECT_ID, NAME FROM ECKERNEL_MCA.OV_AREA WHERE END_DATE IS…
Jayesh
  • 641
  • 4
  • 13
  • 32
1 2 3
…
84 85