Questions tagged [sqltools]
51 questions
0
votes
1 answer
PL SQL + SQL simple statement using substitution variables
I want to create a simple IF THEN ELSE PL SQL without creating an annonymous block like below for use in SQL TOOLS:
variable a varchar2(20)
variable b varchar2(20)
EXEC :a := '&insert_value_a'
EXEC :b := '&insert_value_b'
--this next part I…
user5240377
- 9
- 1
0
votes
1 answer
SQL Primary Key validation in a stored procedure
I have scoured the internet with no luck. I have attached links to the practice set I am working on, but I am creating a stored procedure that needs to update a row after checking if a foreign key from the one table matches with a corresponding…
Sw33tH2O
- 33
- 1
- 1
- 6
0
votes
1 answer
SQL Triggers calling upon multiple tables
I'm creating a row-level trigger for Oracle using SQL Tools. I will attach a picture of the ERD I am working off of. I will also include my instructions, paste what code I have tried, and the error I am getting.
Description of request:
Create a…
Sw33tH2O
- 33
- 1
- 1
- 6
0
votes
0 answers
SQL Tools Include Rows that has null or value of 0
I have been working on this practice problem for SQL class for the past 30 minutes. I am having a hard time including rows that have NULL values in it or a numerical value of 0. I will post the question and then the query that I have…
Sw33tH2O
- 33
- 1
- 1
- 6
0
votes
1 answer
Redgate SQL Data Generator -> Reviewing sqlgen project -> What does "Same as mapped data" mean?
I am reviewing a coworkers sqlgen job and I am unable to figure out what this means in the table generation settings.
Specify number of rows by: "Same as mapped data"
My coworker has this selected on each table, I just need to know what is meant by…
Bill Blankenship
- 3,316
- 6
- 43
- 73
-1
votes
1 answer
How to create a graphical schema for Postgres database?
I have got a sql file where is configured a database in PostgreSQL technology. I created a database from sql file but from code it is hard to understand action/connecting between the tables. Is it some tool which show all the connections between…
andrew
- 3,083
- 4
- 24
- 29