Results 1 to 7 of 7

Thread: Is Select DML?

  1. #1
    Contributing Member
    Join Date
    May 2008
    Answers
    39

    Smile Is Select DML?

    Hi all,

    I have one basic question... My friend was saying SELECT as DML... I told him SELECT won't come under DML.... since it is only retreiving data......

    who is correct?

    Lookin for replies....


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Is Select DML?

    Select is a dml statement.

    Here is the list of dml statements
    select
    delete
    update
    insert
    lock table
    explain plan
    call


  3. #3
    Contributing Member
    Join Date
    May 2008
    Answers
    39

    Re: Is Select DML?

    Krishna,

    Please chk the link.... SQL - Wikipedia, the free encyclopedia

    Regards,
    Karthi


  4. #4
    Contributing Member
    Join Date
    May 2008
    Answers
    39

    Re: Is Select DML?

    It is given that the standard SELECT query is considered separate from SQL DML, as it has no persistent effects on the data stored in a database........


  5. #5
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Is Select DML?

    Your doubt is you are not manipulating database objects using select statement. Just you are selecting or query data from database. So it is not DML statement.

    DML statements do not commit data automatically.
    DDL statements auto commit data.


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Is Select DML?

    Select is not DML .
    It is Data Retrival Language(DRL) since it involvs no data manipulation.


  7. #7
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Is Select DML?

    I have given reply based on oracle documentation.

    Here is the link


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact