SQL – Page 1100 – SQL Questions Answer

How to SELECT all JOBS that using a DBLINK on oracle?

Is my pleasure to say helo to all of you. I need help on oracle to select all JOBS that using a DBLINK on oracle, to stop them during maintenance. I will appreciate your help.

Convert result of CASE Expression to a number in Oracle SQL

case oracle sql

I have the following select query. I want to convert it from string into a number. If I wrap a TO_NUMBER around the case expression, I get expression must have same datatype as corresponding …

Postgresql, Updating table row for each row in another table

I’m doing a project at school in java/postgresql where you can buy tickets to different concerts and I’m stuck at a place where I want to write a code to be able to refund all money if a concert is …

Is it possible to pass a built in function as an argument to a trigger?

I ask this question in light of the following trigger producing this error: ERROR: syntax error at or near “(” LINE 5: …cessBlogPostApproval”(‘Blog Post Approval’, concat(‘Your blo… ^ The …

Listing all transactions of an account from a specific period of time

mysql sql

Get latest record after ordering columns based on sequence

oracle sql

I would like to order my table using two columns in manner of sequence as described: The current balance to start as the previous balance in next row. Below is my data ID_DATE PREV_BAL …

How to retry after sql connection failed in python?

except pyodbc python sql try-catch

Whats the right way to retry when connection/write to a DB fails in python? Im trying to use this code and it works until i restart my sql server and python tries to connect to it i get “retry after …

merging start and end date cycle dates

lead listagg oracle sql

I have the below table. CUST_ID START_CYCLE END_CYCLE WORKER CUST_SUB_ID CUST_SUB_TYPE 101 1/1/2019 1/31/2019 ABC123 134 HIGH_SUB 101 2/1/2019 4/30/2019 ABC123 136 …

Trigger delete on many-to-many middle table deletion

postgresql sql

There are two tables A and B. As they have a many-to-many relation, there’s also table C. A —— id PK B —— id PK C —— id_A PK id_B PK Now, a row B only exists only exists when at least …