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. INSERT  UPDATE DELETE SELECT 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