There are n number of parent tasks and each task has their actual start time and actual end time, now there are child task as well, for one parent task which ends with ‘createprovision’ i want to replace the end time with the start time of the child task which starts with ‘Preparations’…
Tag: oracle
APEX: Submit without refreshing the page
I have an interactive report that runs a large query, which takes about 20 seconds to execute. There are many filter items on the APEX page, which affect the data in the report. The report uses a PL/…
How to Pivot row (Dates of the month ) into columns in sql ? ( without giving the date of the month “for in” )
I have a data table which data as below & every prod_id have an amount daily for the month of Feb. I need to get the output as below Please help ,getting the error of missing right parenthesis FOR DATE IN (DATE) without giving the date of the month (specific as FOR DATE IN (’01-FEB-20′,……
Comparing two dates in Oracle after using TO_DATE function
I have the following Oracle Query that is converting todays date and the date field from the table into the same format. However, when trying to compare the two they aren’t coming up as equal. The cast is used on the field in my table, both these return. However, when adding the following where statemen…
SQL interview questions
Table-1 Table-2 And need output is Answer Here’s one option:
How to break sequence
i have a table named sequence with a single column val and table looks like val —– 1 2 3 5 8 9 10 i need to identify the range of numbers if there is a break in sequence and output like …
Difference between NVL and OR in SQL oracle
Hej guys, could someone explain to me difference between NVL() and OR in below query : Number of rows: 44937 and Number of rows: 44782 Why we have this difference: 155 rows? i built a few query based on nvl and notice that issue and going to switch to OR, but I really want to know, why it such a
how to convert minutes to days in oracle
How would you convert a number of minutes to number of days? For instance, number of minutes is 20160. Now how do I get number of days based on that using SQL?
Selecting new distinct values over time (ORACLE SQL)
I want to select new distinct values and track them over time. I have a table where each row represents a score awarded to a particular person. – timestamp (when the score was awarded) – name (which person received the score) – score (what score the person received) I want the result to look…
Sql query to find the job and grade according to particular column conditions
I have created a query – Now I want the output such that ,according to the value of legal_emp and SAL_hour I will have to calculate grade and job from another table in the same query. Something like – How can i achieve this in a single query ? Answer sounds like CASE WHEN should be able to fix thi…