Oracle DML commands


Oracle DML commands

<<Previous  Next>>     

Oracle - Oracle DML commands - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

What is DML command?

Data manipulation commands are used to manage data. Few such DML commands are:

SELECT - retrieve data from the a database
INSERT - insert data into a table
UPDATE - updates existing data within a table
DELETE - deletes all records from a table.

What is DML command?

Answer - Using DML command, you can create new records, update records and delete records. The following commands fall in this category.


Oracle Import export

What are the use of Export and Import command?, What are the parameters to be provided while executing Export and Import commands?, What is the difference between the SQL*Loader and IMPORT utilities?..............    

Oracle memory area

Software area code: - It is a protected location that is used to store oracle code that is supposed to be run. The location is different from users' programs. The software area code is read only and can be shared or nonshared...............

Oracle replication

Read only replication creates local copy of table data originating from one or more remote master tables. An application can query the data in a read-only table snapshot..............

Oracle Security

Explain the security features in Oracle, What are roles? How can we implement roles?, What is user Account in Oracle database?, What is a trace file and how is it created?, What are Tablespace Quota and default tablespace?............

Oracle table

Explain drop and truncate table command, Write the command to view the structure of the table, What are the limitation of alter command?, Explain Alter Table Command. What are the limitations of Alter Table command?............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring