Insert date into WSH_Delivery_Details_Interface (https://docs.oracle.com/cloud/r13_update17c/scmcs_gs/OEDSC/WSH_DELIVERY_DETAILS_tbl.htm) throws this error Query : insert into …
Tag: oracle
I don’t know how to combine my attributes into a single column for this query
My query is to Produce a list of Employees who work for the cinema with the cinema number 07 and include the cinema name in the result. Arrange the result in ascending order by employee surname. Name …
How to group two table with the same columns doing total of a column value
I have two oracle table with the same columns I want to create a query over those two tables doing total by a column : Table 1 : PRODUCTION_SYSTEM_ID CARD_TYPE TOTAL DATE_CREATION ———–…
How to find the row and column number of a specific cell in sql?
I have a table in SQL database and I want to find the location of a cell like a coordinate and vice versa. Here is an example: 0 1 2 3 …
Oracle max function on timestamp datatype
I want to take a max date from a timestamp datatype in oracle my data look like this id updated_date — ——————- 1 2011-12-21 10:34:24 1 2011-12-21 09:52:15 1 2011-12-21 10:02:49 …
How to convert 2011 -Q4 to 12-31-2011 in oracle sql?
How to convert 2011 -Q4 to 12-31-2011 in Oracle sql?
Conditional Date Comparison and Assignment using Case expression in Oracle SQL
I am new to the site and SQL. I need some help with a case expression. The requirement is as follows: I have a table T1 with two date columns – eff and disc; A second table T2 with 2 date columns -…
Write a query to show ename who don’t have reporting manager in deptno 10 or 30?
This is the emp table given in Oracle SQL. And I need to display the employees who don’t have reporting manager in department 10 or 30. Answer I would use not exists:
Get query result 15 second interval in Oracle
I have following query to get 15 seconds interval. However I want to show also ‘0’ values even if the result doesn’t have value. Here is the Query; select to_char(trunc(sample_time,’hh24′) + (trunc(…
Parent child relationship Join tables in oracle sql
I have a requirement below. Now I have to get output like below How can this be achieved ? I have written the below SQL but parent_position_id is coming, not parent_position_code select hapf….