Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL DML and DDL
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


hiii,

Explain DML,DDL.


Advertisement
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
JDBC - Java Database Connectivity Tutorial
into categories like DML (Data Manipulation language), DDL (Data definition language
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
Advertisements
 

 

 

DMCA.com