DML Statements - Oracle Replication

Q.  Which of the following is / are DML Statements?
- Published on 13 Aug 15

a. Insert
b. Update
c. Create
d. Both A and B

ANSWER: Both A and B
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - Data Manipulation Language (DML) statements are used for managing data within schema objects.

    - Some examples:

    1. SELECT - Retrieve data from the database
    2. INSERT - Insert data into a table
    3. UPDATE - Updates existing data within a table
    4. DELETE - Deletes all records from a table, the space for the records remain
    5. MERGE - UPSERT operation (insert or update)
    6. CALL - Call a PL/SQL or Java subprogram
    7. EXPLAIN PLAN - Explain access path to data
    8. LOCK TABLE - Control concurrency

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)