Select custom output formats from database with SQL
I am planning to make a simple rest service application, and I am currently deciding the architecture. I have decided that I want to write the middle layer in multiple languages, so that it is easy to deploy/integrate with as wide a range of systems as possible.
What happens if computer crashes after giving commit command
If we are updating a field in SQL and ALTER the row also. After giving the COMMIT command, the system is crashed.
Using JDBC to asynchronously read large Oracle table
What strategies can be used to read every row in a large Oracle table, only once, but as fast as possible with JDBC & Java ?
Designing a system to archive databases with referential integrity
I have a very large Oracle database, with many many tables and millions of rows. I need to delete some of the rows end-to-end. By end-to-end, I mean, if I want to delete a row from a table then I must delete all the corresponding records in child tables first and ensure that deletion happens without any constraint violation errors while deleting the parent table entry.
Database data Bucketing Report Design
Here’s the scenario:
I have item x (item_id, customer_number, cost) which can be submitted to another system multiple times over months which may or may not reject item x before finally accepting it at some point.
Database data Bucketing Report Design
Here’s the scenario:
I have item x (item_id, customer_number, cost) which can be submitted to another system multiple times over months which may or may not reject item x before finally accepting it at some point.
Working with two different database types for one application [duplicate]
UPDATE
Issue with aggregate SUM function to add up quantiities at the selected level in oracle analytical view
CREATE OR REPLACE ANALYTIC VIEW inventory_av USING INVENTORY_FACT DIMENSION BY ( inventory_attribute_dim KEY (LOCATION_ID) REFERENCES (LOCATION_ID) HIERARCHIES (inventory_hier DEFAULT) ) MEASURES ( QUANTITY FACT QUANTITY , QUANTITY_SUM as (SUM(QUANTITY)) ); oracle
Why does updating a table take so much longer than inserting all the data in the first place?
I wanted to copy data from a materialized view to a table, only adding sequence value for PK. There are 800k rows of data.
Retrieve the missing doc_no from table in oracle DB [closed]
Closed 9 mins ago.