| Flag this message Is 'select' a part of Oracle DML language [message #339983] |
Sun, 10 August 2008 14:29  |
anishvkurian
Messages: 1
Registered: August 2008
|
Junior Member |
|
|
In the book "OCP Introduction to Oracle 9i : SQL Exam guide (Tata McGraw-Hill Edition 2002)", page number 20 says: "Many developers consider consider this statement(select) to be part of DML operations against the database .However, Oacle DOES NOT. When OCP refers to DML statements, you should make a mental note that Oracle is not refering to the select statement."
and the answer of review question 4 in page number 24 says: " Oracle considers the select command to be part of data manipulation language eventhough it technically doesnt allow you to change the data being stored."
Could you please tell me whether select statement is a part of Oracle DML language or not..
Please bear with me as i am very new to Oracle & SQL.
|
|
|
|
| Re: Flag this message Is 'select' a part of Oracle DML language [message #339991 is a reply to message #339983] |
Sun, 10 August 2008 16:04  |
gintsp
Messages: 118
Registered: February 2007
|
Senior Member |
|
|
Hmm somehow I don;t feel confidence in this book according to these citations. However to be frank I don't feel much confidence to OCP questions and answers at all. Anyway most probably at least for OCP answers you should look in Oracle docs, for version 10g these are here and they say:
<citation start>
Data Manipulation Language (DML) Statements
Data manipulation language (DML) statements access and manipulate data in existing schema objects. These statements do not implicitly commit the current transaction. The data manipulation language statements are:
CALL
DELETE
EXPLAIN PLAN
INSERT
LOCK TABLE
MERGE
SELECT
UPDATE
The SELECT statement is a limited form of DML statement in that it can only access data in the database. It cannot manipulate data in the database, although it can operate on the accessed data before returning the results of the query.
The CALL and EXPLAIN PLAN statements are supported in PL/SQL only when executed dynamically. All other DML statements are fully supported in PL/SQL.
<citation end>
Manipulation doesn't mean always change, You can take something and manipulate with it, without any changes to it or things around, so the same is true also for select 
Gints Plivna
[Updated on: Sun, 10 August 2008 23:49] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
