Data Manipulation Language

learn more… | top users | synonyms

4
votes
2answers
11k views

Is commit necessary after DML operation in Function/Procedure?

I wonder to know if it is necessary to write commit after insert/delete/update in function/procedure? Example: create or replace function test_fun return number is begin delete from a; return ...
3
votes
2answers
1k views

Does the SELECT statement count into DML?

Looking at the name Data Manipulation Language (DML) I would assume, that all contained statements are actually for manipulating data. As far as I know the SELECT statement can only be used to query ...
0
votes
2answers
118 views

Best way to get the most recent insert from a table (SQL Server) [on hold]

I have an app (which I have no control of) that writes the status (success or failed) of the file transaction to tableA in a DB on SQL Server 2008. I basically want to grab the most recent insert in ...