Questions tagged [dml]

Data Manipulation Language

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
231 views

PostgreSQL DML statements

I am trying to trick an application into executing a DML statement AFTER starting a SELECT statement without using stacked queries so I cannot use the ; character anywhere in my query. I have resorted ...
0
votes
2answers
70 views

Update data from one table to another in sql server

I have a log table where accidentally one date column got updated with current date for 9 Million records. Luckily I had a backup table, so now I want to populate data from backup table to current ...
0
votes
1answer
44 views

Need a better way to insert non-existent values in referenced table during insert/update in referencing one

I'm looking for the best way to insert data into MariaDB with JDBC. Please take a look at the following schema CREATE TABLE color ( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name VARCHAR(...
0
votes
1answer
92 views

What is dml unplanned request?

Can someone please explain me what an unplanned DML request is? According to the book I read, an unplanned request is an ad hoc query, a request for which the need was not seen in advance. Can you ...
0
votes
1answer
302 views

Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?

DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider ...