To work with uni labs I need to write procedures and so that I need to execute given settings script with a command SET TERM ; ^. Executing this produces this error: [42000][335544634] Dynamic SQL ...

I have two vectors of equal length, one integer vector and one boolean vector. I want to calculate the product of elements in the integer vector where the corresponding boolean vector has consecutive ...

I have a case where I need to filter for the partial date string from a column. Here is the input: date_value ----------------------------- 7-03 start 4444 03/2022 follow up 1111 7-03 03/2022 ...

I have implemented this code to add a check constraint after creating the table ALTER TABLE recruitment_data.candidate_experiences ADD CONSTRAINT chk_experience_dates CHECK ( ...

I have a DolphinDB table with an array vector column. I need to remove duplicate rows based on subset relationships within that column. Sample Input: sym prices a [3,4,5,6] a [3,4,5] a [2,4,5,6] a [5,...

I'm working in Teradata SQL Assistant and I need to create a stored procedure that, given a table name, returns the percentage of NULL values for each column in that table. Right now, I generate the ...

AWS documentation for querying Redshift's super is very much all in on supers that are arrays. But, I happen to want a super that is a map, as I'm sure a number of people do, and I would like to then ...

I have the following SQL statement that works correctly strSQL = "SELECT well_API_14," & selectedField & ",ProductionMonth, Well_Name FROM PIH_Monthly_Allocated_Volumes where ...

I have an employee Manager table where you can see for every deptID, there are multiple rows. A few rows have null employeename and a few rows have null managername for same DeptID. i would like to ...

We have got a table with a identifier, a key/value pairs and a start and end timestamp which indicates the valid period for the values. MASTER_WORK_ORDR_ID START_TS END_TS WORK_ORDR_ID_CTXT ...

For example, I have this table below, how can I display only the records that aren't in the 10 minutes range. In this example should return the first and last in note examples user_id | ...

I know I need to add it into the command, otherwise I have to rewrite the report without the command (it crashes that way due to too much data in prod). But I don't know how to write it into the ...

I am trying to find an Oracle SQL to test whether a table (CONTACTS) contains two rows of data for each primary key (PK) called REF_NO. The table has a PK called REF_NO and a second PK called CONT_IND....

I was wondering if there is any privilege or work around that allows a read-only user I created on Oracle to see the DDL of procedure/view/function from third party apps like SQL Developer. Currently ...

SELECT tt.trans_type_name AS transaction_type, trans.transaction_time, a.trans_action_name AS transaction_action_name, trans.transaction_notes FROM(SELECT Cast(...