Results 1 to 6 of 6

Thread: How to differentiate between DDL, DML or DCL commands

  1. #1
    Join Date
    May 2009
    Posts
    1,954

    How to differentiate between DDL, DML or DCL commands

    Hi,
    To create a query on a database I am getting confused between some SQL commands. They are DDL, DML or DCL commands. I have a database which is needed to link with a small table. For that I had tried to create everything but for passing on the commands errors pops out. How can I differentiate between this three languages of SQL. Thank in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,949

    Re: How to differentiate between DDL, DML or DCL commands

    The SQL is divided into various languages to be the defining elements of a database or data handling or management of access rights to data and transactions or data mining. It is a declarative language like that is to say that you specify the properties of data that you want without manipulating logically implement procedures that allow physical manipulation.

  3. #3
    Join Date
    May 2008
    Posts
    2,015

    Re: How to differentiate between DDL, DML or DCL commands

    Language data description (DDL Data Definition Language). It contains three commands that allow the administration of a database, these commands are: First CREATE used to Create tables or indexes. Then ALTER used for Changing tables or indexes and the DROP which is used to Remove table or index. The generator included tools in our workshop Oracle Designer allows us to generate scripts for multiple products or versions. The code for creating database can only be issued either as scripts or either be executed directly on the targeted database.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,010

    Re: How to differentiate between DDL, DML or DCL commands

    DML stands for Data Manipulation Language. It is the Language of ata manipulation which includes three commands for the latest data from a table, these commands. They are Insert which is used to add new rows into a table. The second one is update which updates some fields in a row in a table and Delete to removing unnecessary rows in a table.

  5. #5
    Join Date
    May 2008
    Posts
    2,302

    Re: How to differentiate between DDL, DML or DCL commands

    DCL commands are Data Control Language. The different commands which come under this is Grant for assigning access rights, Revoke to remove access rights, Commit for taking account of recent transactions for updated data and Rollback for removal of recent transactions and restore the old data. The code for creating database may be issued in the form of scripts or run directly on the targeted database. These options DDL Files Only, or ODBC Database above. In all cases, scripts will be created and registered by setting attributes Prefix File and Directory.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,394

    Re: How to differentiate between DDL, DML or DCL commands

    Query language data (for DQL Data Query Language). Although consisting of only one SELECT statement, the latter being the most used because if the population of a database is an important step, the various requests for data extraction are important steps for all type of use. The command for it is SELECT which Extracts data are projected by selection with restrictions or by grouping.

Similar Threads

  1. How to differentiate between ASUS Sabertooth versions?
    By sHaRiCe in forum Motherboard Processor & RAM
    Replies: 7
    Last Post: 09-10-2011, 11:08 PM
  2. Cannot differentiate between a primary key and a Super key
    By GOOL in forum Software Development
    Replies: 4
    Last Post: 29-12-2010, 04:54 AM
  3. How to differentiate 2 constructors with the same parameters?
    By Juany in forum Software Development
    Replies: 5
    Last Post: 15-03-2010, 04:01 PM
  4. Differentiate between const and static readonly
    By KALLIYAN in forum Software Development
    Replies: 3
    Last Post: 16-11-2009, 11:52 PM
  5. Need Basic Dos commands for Commands prompt
    By JangoRap in forum Operating Systems
    Replies: 5
    Last Post: 29-06-2009, 12:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •