Stack Overflow
Stack Overflow

Questions tagged [dml]

Data Manipulation Language(DML) is database syntax used for SQL commands, including the INSERT, UPDATE, and DELETE statements. DML triggers operate on INSERT, UPDATE, and DELETE statements, and help to enforce business rules and extend data integrity when data is modified in tables or views.

A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database. Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

References:

DML related tags

539 questions
0
votes
1 answer

DbLinq DbMetal - "The given key was not present in the dictionary" when adding Foreign Key

This is my initial SQLite database CREATE TABLE [Categories] ( [ParentId] INT, [Name] VARCHAR(100)); CREATE TABLE [Fees] ( [CategoryId] INT, [Name] VARCHAR(100), [Value] VARCHAR(50), [Info] VARCHAR(200)); CREATE TABLE [Markups] ( …
Aximili
  • 28,626
  • 56
  • 157
  • 216
0
votes
1 answer

conditional UPDATE in ORACLE with subquery

I have a table ( table1 ) that represents item grouping and another table ( table2 ) that represents the items themselves. table1.id is foreign key to table2 and in every record of table1 I also collect information like the total number of records…
user957316
  • 23
  • 2
0
votes
3 answers

Change data type of a column with dependencies from integer to numeric

I need to change a data type in a table, but run into a dependency error. Is possible to change the data type of an INTEGER column to NUMERIC directly in pg_attribute? I've tried with ALTER TABLE and it does not work: CREATE TABLE documento ( …
atiruz
  • 2,782
  • 27
  • 36
0
votes
1 answer

Is there is way to execute raw sql before every INSERT/UPDATE/DELETE in django?

I need to set variable in db scope what will containt django user id what making DML query. something like this : CREATE OR REPLACE FUNCTION set_user_id(auser_id integer) RETURNS void AS 'GD["user_id"] = auser_id' LANGUAGE plpythonu VOLATILE …
Andrey Baryshnikov
  • 781
  • 2
  • 12
  • 22
-1
votes
1 answer

BigQuery rateLimitExceeded Error with DML insert on cloud function trigger

I have a firestore collection structure as follows: /documents/{documentID}/events/{eventId}. I want to insert a row into a BigQuery table using a firebase trigger function, which listens to the events collection…
melihozcann
  • 403
  • 1
  • 4
  • 9
-1
votes
1 answer

Calculating the percentage of different types of customer feedback in each quarter

The problem statement is: I have a table (order_t) which has customer feedback (one column) and quarter number (as another column). Using a CTE, I need to calculate the percentage of number of customer feedback in each category as well as the total…
Drishan Vig
  • 1
  • 1
-1
votes
2 answers

What will happen if I execute rollback statement on simple select query

I executed a simple SQL performance query to retrieve the sessions running currently in the database in Oracle sql developer. But accidentally my cursor clicked on the roll back icon and it got rolled back. Could you please tell me What happens to…
pooja
  • 1
-1
votes
2 answers

Oracle express edition 10g trigger problem at runtime

Below image is showing error. error screenshot I have created this simple trigger in plsql. CREATE OR REPLACE TRIGGER TR6 BEFORE UPDATE ON EMPLOYEE FOR EACH ROW BEGIN INSERT INTO PRAC14 (EMP_NO,EMP_NAME,EMP_SAL,DEPT_NO) …
Ridham Karia
  • 23
  • 5
-1
votes
1 answer

How to write DB2 DDL & DML audit logs as System Application Logs?

I am using DB2 LUW in a windows machine. I want to get the logs for DDL & DML queries used in the database. The default logs(for example S000001.LOG) contains 'null' and not in a readable format. So I enabled auditing and extracted the archived…
Selva
  • 25
  • 6
-1
votes
1 answer

Is JOIN operation ddl?

As join command joins 2 tables, is it like changing the schema for it to be considered a DDL?
user7059217
-1
votes
2 answers

Is there a package offered by Oracle to get the events/actions when an INSERT, UPDATE, or DELETE has happened in a specific table?

I'm currently writing a PLSQL script that needs to capture whenever one of the DML events has occurred in a table. I'm trying to do it all in one trigger to capture these events without splitting them up into three separate triggers if possible. Any…
codemonkey
  • 515
  • 2
  • 6
  • 18
-1
votes
3 answers

What is the maximum # of rows in a LEFT OUTER JOIN?

For any two given tables, say table 1 has i rows and table 2 has j rows, can someone explain to me how it is possible that we end up with a total of i * j rows in a LEFT OUTER JOIN if table 1 is the "left" table ? I always thought that a LEFT OUTER…
oneCoderToRuleThemAll
  • 834
  • 2
  • 12
  • 33
-1
votes
1 answer

PL/SQL Errors Suddenly

I am developing a PL/SQL script, using TOAD. At this point of the development, I am debugging it. This has involved: wrap a section in begin/end, F5 run it, receive error info, fix problem, repeat. All of a sudden, out of nowhere, I am receiving …
Brian Wren
  • 367
  • 5
  • 15
-1
votes
1 answer

SQL Server : data not being inserted

I am writing a sample application to insert data into a SQL Server database using C#. Data is not persisting in the database. Below is my code: conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType =…
Toshif Khan
  • 1
  • 1
-1
votes
2 answers

ORACLE SQL: how to update a table based in another column?

So, i have two tables, INTERNAMENTO and DOC_ADMISSAO2. i want to update a column from table INTERNAMENTO named DIASINTERNAMENTO with the same values of the table DOC_ADMISSAO2 called DIASADMISSAO, with some conditions.. update INTERNAMENTO a set…
newUser
  • 102
  • 8
1 2 3
…
35
36