Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to differentiate between DDL, DML or DCL commands

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-02-2010
Member
 
Join Date: May 2009
Posts: 1,945
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.

Reply With Quote
  #2  
Old 27-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,948
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.
Reply With Quote
  #3  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,007
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.
Reply With Quote
  #4  
Old 27-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,000
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.
Reply With Quote
  #5  
Old 27-02-2010
Member
 
Join Date: May 2008
Posts: 2,292
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.
Reply With Quote
  #6  
Old 27-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to differentiate between DDL, DML or DCL commands"
Thread Thread Starter Forum Replies Last Post
How to differentiate between ASUS Sabertooth versions? sHaRiCe Motherboard Processor & RAM 7 10-10-2011 12:08 AM
Cannot differentiate between a primary key and a Super key GOOL Software Development 4 29-12-2010 05:54 AM
How to differentiate 2 constructors with the same parameters? Juany Software Development 5 15-03-2010 05:01 PM
Differentiate between const and static readonly KALLIYAN Software Development 3 17-11-2009 12:52 AM
Need Basic Dos commands for Commands prompt JangoRap Operating Systems 5 29-06-2009 01:07 PM


All times are GMT +5.5. The time now is 12:30 PM.