Share on Google+Share on Google+

samar
DML and DDL
1 Answer(s)      6 years and 6 months ago
Posted in : SQL

hiii,

Explain DML,DDL.

Ads

View Answers

October 28, 2010 at 4:38 PM


HELLO,

Data Definition Language (DDL) statements are used to define the database structure or schema.

CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME

Data Manipulation Language (DML) statements are used for managing data within schema objects.

SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, EXPLAIN PLAN, LOCK TABLE










Related Tutorials/Questions & Answers:
DML and DDL
DML and DDL   hiii, Explain DML,DDL.   HELLO, Data Definition Language (DDL) statements are used to define the database structure... (DML) statements are used for managing data within schema objects. SELECT
What is DML,DDL?
What is DML,DDL?  What is DML,DDL?   Hi, Data Definition Language (DDL): statements are used to define the database structure or schema. Examples: CREATE, ALTER, DROP statements Data Manipulation Language (DML
Advertisements
netbeans ddl and dml sql statements - Java Beginners
netbeans ddl and dml sql statements  Kindly send me the ddl,dml and tcl commands while in netbeans. wilson
What is DML?
What is DML?  What is DML
Common SQL Commands
are divided into categories like DML (Data Manipulation language), DDL (Data...). Here are a list of SQL commands. 1. DML COMMANDS INSERTUPDATESELECTDELETE... Ajay  The commands are based on this table: 1. DML COMMANDS
Difference between TRUNCATE and DELETE commands
Difference between TRUNCATE and DELETE commands  hii, What is the difference between TRUNCATE and DELETE commands?   hello, TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much faster than
SQL Plus
the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query
sql - SQL
(select,insert,update etc.), manipulate objects(DDL) and data(DML). PL/SQL... the database how to do things (procedural). 3 SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions
SQL-introduction
(DDL) and data manipulation language (DML). Data Definition Language
Jsp program
Jsp program  A sample program of jsp using dml quaries
What does COMMIT do?
What does COMMIT do?  What does COMMIT do?   Hi, here is the answer, COMMIT makes permanent the changes made by DML statements in the transaction. The changes made by the DML statements of a transaction become
Hibernate Association and join
Hibernate Association and join  hi, can u please tell me SQL DDL queries to create Product and Dealer table... and also tell me java code for Product and Dealer bean
Oracle Tutorial
be categorized into the following statements : DDL (Data Definition Language) : Provide create, alter, maintain, drop, grant operations. DML(Data
Types of Triggers
Types of Triggers   hii, How many types of Triggers in sql?   hello, there are three type of trigger DML triggers Instead of triggers System triggers
Advanced Java Training
DDL -- Creating and Managing Database Objects DML -- Retrieving
Advanced Java Tutorials
and Vendor Implementations Introduction to DDL (Creating and Managing Database Objects) and DML (Retrieving and Managing Data
Eclipse Plunging-Database
a database model and generate the SQL (DDL) code appropriate for your database. Clay..., McKoi); generates SQL (DDL) script; database model validation. Clay Pro adds... persistence code, persistence layer and database (DDL or direct execute to the database
SQL
table replicates 7)Gather statistics on table access 8)Modify table data when DML... events, user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
replicates 7)Gather statistics on table access 8)Modify table data when DML..., user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
table replicates 7)Gather statistics on table access 8)Modify table data when DML..., user events, and SQL statements to subscribing applications 10)Restrict DML
SQL
replicates 7)Gather statistics on table access 8)Modify table data when DML... events, and SQL statements to subscribing applications 10)Restrict DML
EntityCreator
of executing easy DML are generated. It corresponds to Oracle, PostgreSQL, and MySQL
Database Modeling in Eclipse
. Furthermore, Clay generates the SQL (DDL) code appropriate for your database. Clay Core.... User-configurable SQL script generation. Generates the DDL script appropriate
Database Modeling in Eclipse
. Furthermore, Clay generates the SQL (DDL) code appropriate for your database. Clay Core.... User-configurable SQL script generation. Generates the DDL script appropriate
JPA 2.1 New Features
ADS4ThUnitADS Packaged scripts support: Now ddl-create-script, ddl-drop-script, ddl-load-script scripts can be used. Schema generation
Introduction to Hibernate
) operations using simple API, and generates DDL scripts to create DB schema (tables
JDBC Training, Learn JDBC yourself
; Common SQL Commands SQL commands are divided into categories like DML (Data Manipulation language), DDL (Data definition language), TCL (Tranction control
IBM Cloudscape Workbench
their DDL (Data Definition Language). Drop objects. Generate DDL scripts
Hibernate 3.1.1 Released
, especially regarding: SQL Server support DML-style HQL (UPDATE, DELETE, INSERT...: DML-style HQL queries and associations FORWARD_ONLY ScrollableResults
QiQu
. (XML, HTML, DDL-Scripts, Excel etc.). If the converting features of QiQu do
JDBC - Java Database Connectivity Tutorial
Commands SQL commands are divided into categories like DML (Data Manipulation language), DDL (Data definition language), TCL (Tranction control language
Tutorials   
Java Spring Hibernate Struts Training How to Fetch Data using dropdown option How to get day from date in SQL? Example of sorting results in MySQL Distinct and Limit example in MySQL How to download install and use MySQL workbench? Example of Average, Sum, Min and Max functions in MySQL How to delete data from MySQL? Update SQL Query Example Order by example in MySQL AND and OR Operators in MySQL Query Where clause with query in MySQL How to use select Statement in MySQL? How to insert data into MySQL Table? Create Database and tables in MySQL example of before insert trigger in mysql Failed to Call Procedure MY Sql Query Error - Not able to Understand the issue which query will be run for previous(button) question How to access data yearly from DB in C# ? Fastest way to upload huge raw data in database - c#, Java or stored procedure DB Insert Nb hours between 2 time stamps meets specific criteria mysql select into table from another table example MySQLselect into new table Example code How to create a .mdf file from script (.sql) Please help me out fixing broken relational links in MySQL database after an upgrade How do I upgrade mysql? mysql 4.x to 5.x upgrade problem Upgrading a PHP/MYSQL application? upgrading sql query join phpmyadmin in whm whm php version update php cpanel cpanel mysql downgrade cpanel mysql version upgrade mysql whm upgrade mysql 4 5 cpanel upgrade mysql cpanel server Did my upgrade from mySQL 5.1 to 5.5 work Upgrade to MySQL 5.5 ? - cPanel Mem use upgrade from MySQL 5.1 to 5.5 - cPanel Upgrading MySQL from 5.0 to 5.1 or 5.5 - cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel Updating from MySQL 5.0 to 5.5 cPanel MySQL 5.1 upgrade to 5.5 error Charset problem upon publishing PHP + MySQL website MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist SQL Error Version 5.5.15

Ads

 
Advertisement null

Ads