Topic: Explain DDL and DML
Not finding your answer? Try searching the web for Explain DDL and DML
Answers to Common Questions
What is ddl and dml in sql 2000?
SQL These are the main categories are DDL(Data Definition Language) DML ( Data Manipulation Language) DQL( Data Query Language) DCL( Data control Language) Data administration commands Transactional control command. ddl includes insert ,del... Read More »
Source: http://wiki.answers.com/Q/What_is_ddl_and_dml_in_sql_2000
What is the full form of ddl and dml?
ddl: data definition language dml: data manipulation language Read More »
Source: http://wiki.answers.com/Q/What_is_the_full_form_of_ddl_and_dml
What is ddl dml tcl dql dcl?
DDL statements -Data Definition Language It is used to Retrive,Store,Modify,Delete,Insert,update data in database. 1) Create 2) Alter 3) Drop DML Statements.-Data Manipulation Languag It is used to create and modify the structure of databas... Read More »
Source: http://wiki.answers.com/Q/What_is_ddl_dml_tcl_dql_dcl
More Common Questions
Answers to Other Common Questions
DDL = data definition language - the set of commands for creating, altering and dropping tables, indexes, views, triggers, etc. The language of the "structure" of a database DML= data manipulation language - the set of command for manipu...
Read More »
Source: http://www.experts-exchange.com/Web_Development/Scripting/PHP_Ins...
1: I believe the table gets created first then the select executes. I'm not sure how I can 'stage' a select failure in a demo to prove it. 2&3: you either get all the rows or you don't. If there's no 'commit', the changes never really happe...
Read More »
Source: http://www.experts-exchange.com/Q_26237096.htm
Hi Nandini, I checked the flw query for a procedure containing INSERT/DELETE stmts: SELECT * FROM v$SQLAREA S, dba_users U WHERE UPPER(S.SQL_TEXT) LIKE '%SPECIFY_TABLE_NAME_HERE%' and U.user_id = S.PARSING_USER_ID and UPPER(U.USERNAME) = 'S...
Read More »
Source: http://www.experts-exchange.com/Q_20929838.htm
In the v$session table is a column named Last_Call_et. This is the number of seconds since the last session call was made. If you want to see this as a time, you can do something like this... SQL> select sid,username,last_call_et, 2 t...
Read More »
Source: http://www.experts-exchange.com/Q_21748205.htm
try this, i found it online Sub Test_Work() 'Dim cn As Object, rs As Object, r As Long, cmdstr As String, sql As String 'Set cn = CreateObject("ADODB.Connection") 'cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ '"Data Source=D:\Documents ...
Read More »
Source: http://answers.yahoo.com/question/index?qid=20071211042402AAcTSyh
The SQL sentences that are used to create objects are called DDL's or Data Definition Language. The SQL sentences used to manipulate data within these objects are called DML's Data Manipulation Language.
Read More »
Source: http://www.geekinterview.com/question_details/12782
I have read somewhere as DDL statement as it has implicit commit statement.
Read More »
Source: http://www.geekinterview.com/FAQs/Oracle/Database/page11
