I am running this in TOAD. Please forgive my ignorance, I am new to SQL. it ran once and gave me all of the data I was looking for but now when I execute this query, I keep getting Database Error ‘SQL Server Database Error Conversion failed when converting the nvarchar value ‘ ‘ to data type int. ‘ Answer
Tag: toad
How to filter out a column value when another column contains a value in SQl
How can I filter out a value in one column if a value in another column is present? I’m trying to remove all C’s in the CODE column if it is accompanied by a ‘-‘ in the Description column. In the ‘CODE’ column, I want to remove the values ‘C’ if the Description = ‘-‘. The end result would look
Compare Columns from Separate Schema in SQL using TOAD Oracle
I am trying to extract data via a unique identifier from two separate schema in TOAD for Oracle using SQL. Normally, I would export to Python and work the csv from there, however, in this case, I must …
Toad Notation – What do (Ix#)’s mean?
So, I’m trying to visualize a database, and I have some tables put together which consist of a mix of object-oriented and relational; just trying to tie them together. My issue is, I can’t seem to …
If there is data linked to an order number, how do i pull some but not the other (not exists?)?
I’m using Toad for Oracle. I currently have Order Numbers with items in both our yard and our warehouse. I’m looking to see items that ONLY have items in the yard. Essentially I need a count of the …
How to get my PUT_LINE statement to display in TOAD?
This code compiles, but in TOAD it won’t show the “hi wo” output CREATE OR REPLACE PROCEDURE AdelTest IS tmpVar NUMBER; BEGIN DBMS_OUTPUT.ENABLE(100: in INTEGER); DBMS_OUTPUT.PUT_LINE(‘hi wo’); …
Variables in TOAD scripts
I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement after statement, thusly: And so on. Some of the where clauses end up being repetitive because I have complex inner queries to get particular IDs to operate on. I’d like to capture the ID in the beginning of the script