My database is for a school project and handles various jobs/contracts which are ran by consultants. Apologies if the context is vague, we haven’t really been given much either. My current code does …
Tag: oracle
Is there a way to generate an automated email if no changes have been made to a column for a specific period of time?
I’m trying to generate an automated email if no change occurs to a specific column on my database. I have a “Description” column on my database with different entries but the one that i want to …
What should I use instead of sequence in order to avoid gaps?
I’m developing a system that allows to organise paper documents in folders. When folder is full, user hits ‘New folder’ button. This action calls nextval() of sequence of folders. Here is how this …
Way to alter one table if another was altered
For example, I am having table T1 and archive table T1_A Create table T1(n number); Create table T1_A(archieve_dt date,n number); To make activation working correctly if I am adding a column to T1 …
SQL perform AVG after MAX
I have two tables. Table1: | ID1 | ID2 | ID3 | ID4 | |—–+—–+—–+—–| | 200 | 125 | 300 | 201 | | 206 | 128 | 650 | 261 | | 230 | 543 | 989 | 403 | and Table2: | ID1 | ID2 | ID3 | ID4 | …
How to convert decimal to time in Oracle SQL?
In a certain table I’m querying, time is stored like this: 09:30 is stored as 9,3 14:25 is stored as 14,25 How can I, using SQL, convert 9,3 to 09:30 (hh:mm format)? So far, the only thing I could …
How to write Like Condition within In Clause for thousands of Items
i want to filter Items of table PartMaster based on the input from table PARTINPUT using LIKE condition. Both the table has multiple entries. Table 1: PartMaster PartNo ====== Part1.DRW Part2.DRW …
How to number rows according to values in columns
Imagine I have an event log (ordered by UserID and Start, Start_of_previous_event is added using LAG(), inactive time = Start – Start_of_previous_event): UserID Event Start …
bad date format for pivot
together I can not figure out why in PowerPivot or Excel a Microsoft query does not provide the date fields in the format for Excel as they are necessary. I have already gotten from you in another …
Column Concatenation in Oracle [closed]
I’m trying to Concatenate these three columns into one but having the error, any help? WITH ABC AS (select tsk.task_number || ‘ / ‘|| tsk.task_status|| ‘ / ‘|| tsk.summary, CSI….