Results 1 to 10 of 10
  1. #1
    Join Date
    May 2012
    Posts
    4

    Lightbulb DML Sentences role in Data Dictionary

    Dear Friends, hi,
    Changing Data dictionary by DML Sentences (e.g Insert, Delete, Update,...), Will be possible? Or just by DDL Sentences? Please explain with an example. Thank you

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    changing data dictionary by DML will be possible?

    no, only DDL

    example: ALTER TABLE
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2012
    Posts
    4
    Tank you
    DDL only work with structures (Metadata), no data. So how can the data be manipulated? According to this view (your Post), the data dictionary is empty of data? However, DML commands do not have any role in Data dictionary or system catalog? However, the permissions granted to users, such as insert, Delete, Search ,... What is the meaning? This means permission to use these commands, work with data or not?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Student-09 View Post
    Tank you
    you're wecome
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2012
    Posts
    4
    I don't understand!
    I asked a question, you're not accountable?
    Ok, no problem.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    accountable?

    wtf?

    how much are you paying for these answers? what was the entry fee to register on this forum? where are the service agreements that outlined how quickly all your questions would be answered?

    please, grow a pair

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    May 2012
    Posts
    4
    Exactly, I did not pay any money! I do not expect. I said do not you answer me?
    I just wanted to help! I have no expectations.

    Thank you again. Be successful.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    DDL data defintion language
    DML data manipulation language
    both are subsets of SQL

    DDL affects the design and structure of the db
    DML affects the data inside the db

    eg
    Code:
    SELECT myDB;
    DROP TABLE mytable;
    is DDL to delete a table (mytable) from a database (MyDB)
    Code:
    SELECT myDB;
    TRUNCATE TABLE mytable;
    is DDL to delete all the data in a table
    which is functionally the same as
    Code:
    SELECT myDB;
    DELETE * from mytable;
    which is DML to delete all the data in a table

    Code:
    SELECT myDB;
    SELECT quantity * price as SalesValue from mysalestable;
    is DML to calculate the sales value by multiplying quantity by price to give SalesValue

    if you njeed further examples and instruction I'd suggest you attend class, read some books or look at the stuff on teaching resourtces such as W3schools
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by healdem View Post
    Code:
    SELECT myDB
    perhaps you meant to say USE instead of SELECT


    Quote Originally Posted by healdem View Post
    ... such as W3schools
    poor choice

    see W3Fools.com

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    SQL is NOT the only database technology that uses DDL and DML.

    Every database system that i've worked with (more than 15) has these (one way or another) - without them there would be no database systems. Ya gotta define "stuff" and then you have to use it (read, write, insert, delete) and DDL and DML is the way databases are set up.

Posting Permissions

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