Home » SQL & PL/SQL » Client Tools » sql vs isql*Plus
sql vs isql*Plus [message #236136] Wed, 09 May 2007 02:57 Go to next message
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 #236144 is a reply to message #236136] Wed, 09 May 2007 03:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Source? Post links.

Btw, SQL is a language, iSQL*Plus is a tool.

Regards
Michel
Re: sql vs isql*Plus [message #236150 is a reply to message #236136] Wed, 09 May 2007 03:30 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Output Window For TOAD
Next Topic: iSQL*PLUS
Goto Forum:
  


Current Time: Wed Dec 07 03:02:56 CST 2016

Total time taken to generate the page: 0.16812 seconds