MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology


DML (Data manipulation language)
Previous Home Next

DML statements are used to work with the data in tables. SELECT, INSERT, UPDATE, DELETE statements are consider as a DML statement.

  1. SELECT: SQL server provide the SELECT statement to retrieve data  from database. The keywords SELECT, FROM and WHERE makeup the basic SELECT statement . SELECT statement promote the server to querying single table or multiple tables in Database and prepare a result and return to the client application.
  2. Selecting Columns

    The column name from a table specified in the SELECT statement separated by a comma (,) and there is no need to insert a comma after the last column name.

    SELECT column_name 1,column_name 2....column_name n 
    FROM table_name

    The above query retrieve the column data  which you pass in the query from table which you pass after From keyword.

    Selecting All Columns

    The SELECT statement used with an asterisk (*) symbol to display all column of the table

    SELECT * 
    FROM table_name
  3. INSERT: The insert statement is used to add new rows to a table. There will need a separate INSERT statement for every row. The statement of Insert will be:
  4. INSERT INTO table_name VALUES (value 1, ... value n); 
    1. The number of attributes and the data type of each attribute.
    2. Character type values are always enclosed in single quotes.
    3. Number values are never in quote.
    4. Date values are often in the format 'yyyy-mm-dd' (for example, '2010-12-24').
  5. UPDATE: The update statement is used to change values that are already in a table.
  6. UPDATE table_name SET attribute_name 1 = value 1,  
    attribute_name 2 = value 2....attribute_name n = value n 
    WHERE condition;

If the WHERE clause is omitted, then the specified attribute is set to the same value in every row of the table

Set multiple attribute values at the same time with a comma-delimited list of attribute_name=value pair

The delete statement does just that, for rows in a table.

DELETE FROM table_name 
WHERE condition

If the WHERE clause is omitted, then every row of the table is deleted

  • CALL: Call a PL/SQL
  • EXPLAIN PLAN: Explain access path to data
  • LOCK TABLE: Control concurrency
  • Previous Home Next