| sql vs isql*Plus [message #236136] |
Wed, 09 May 2007 02:57  |
knight07
Messages: 8
Registered: April 2007
|
Junior Member |
|
|
Hello all: I am confused with the two statements that I read in an oracle training material"
"SQL: retrieves data: manipulates data and table definitions in the database".
"iSQL*Plus: Does not allow manipulation of values in the database".
I always use iSQL*Plus and it seems that I'm manipulating values in the database using SQL statements . . .
what am I not getting in the second statement?
|
|
|
|
|
|
| Re: sql vs isql*Plus [message #236150 is a reply to message #236136] |
Wed, 09 May 2007 03:30  |
knight07
Messages: 8
Registered: April 2007
|
Junior Member |
|
|
Thanx Michel:
The source is an oracle training material, "Oracle Database 10g: SQL Fundamentals I Volume I. Student Guide" p 1-22.
What I did't get is that how the isql*plus commands do not allow manipulation of values in the database!
What then am I doing when using DMLs and DDLs and 'commit' in specific?
[Updated on: Wed, 09 May 2007 03:32] Report message to a moderator |
|
|
|
| Re: sql vs isql*Plus [message #236152 is a reply to message #236150] |
Wed, 09 May 2007 03:34 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Ask teacher what this sentence means.
Of course, DML "manipulates" values and can store them in database and iSQL*Plus is designed to make DML.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
