I am looking to create a recursive query that is able to completely map a series of replenishments, to a top level requirement. Below is some detailed information regarding my problem statement: I …
Tag: oracle11g
INSERT INTO failing on SQL Fiddle
I am trying to create a SQL Fiddle for creating a test database. My query is below: — schema CREATE TABLE tblInputs ( Type VARCHAR(256), Order_No VARCHAR(256), Planned_No VARCHAR(256), …
Oracle Compound Trigger : PLS-00103 Encountered when Attempting to get Max of Date Column
I am trying to construct a trigger that will update Table B with Max value end_date column when the corresponding end_date of table A is updated. This is so I can calculated and save the date …
NULL fields using PIVOT
I request your collaboration because pivot on a table and separating the records by null, but still leave the fields at 0 with NVL Table product | value ———-+——- Shirts | 1200 Caps …
Oracle SQL – return the date record when there is no count result
I have the tables below and I need my query to bring me the amount of operations grouped by date. For the dates on which there will be no operations, I need to return the date anyway with the zero …
how to solve this query using union
Display id and name for salesmen along with id and category of products in a single table. Indicate the source of the row in result by adding an additional column TYPE with possible values as ‘S’ (Salesman) and ‘P’ (Product). Display all rows. I don’t how to add column “type” without using alter actual tables are Salesman Table Product Table
Find out users who do not have a particular role
I have a set of DB roles defined in my oracle database. say VIEWER- Select only UPDATER – select & update only EDITOR – select & delete only BYPASSER- select & insert only And I have a …
What is the syntax for merge-delete target rows with filter?
I’m learning SQL on Oracle Dev Gym. I’m taking the class Databases for Developers: Next Level: Merge, by Chris Saxon. I can’t for the life of me figure out how to delete rows with filter in the …
How to get column names from a query?
I have a specific query with joins and aliases, and I need to retrieve columns name for a REST request in Talend. I’m using Talend Open Studio for Data Integration 6.2 and I’ve got an Oracle 11g …
Execute two UPDATEs on complementary data at once in Oracle
I have the following table that I need to update: USER: | ID | ACTIVE | REF_COL | COL_2 | COL_3 | |—-|——–|———|——-|——-| | 1 | 1 | value | value | value | | 2 | 0 | …