Quote:
Originally posted by rmill9681
1. I have heard about Oracle, MySQL, and MS-SQL. Are these servers? Is database server a more accurate description? Would Apache be a web server and not related to Oracle, MySQL, etc.?
|
Oracle, MySQL an MS-SQL are database servers, Apache is a webserver, it has no interaction with any database server, languages like PHP are there for the webserver to perform actions uppon the database server and report the results back through the webserver.
Quote:
Originally posted by rmill9681
2. Is MySQL a server and a language?
|
In any database server there is a language with which you can ask it to return/perform actions onto the data stored in it, for MySQL theres a certain syntax, it might be similar to Oracle or MS-SQL but depending on the databse, the syntax may vary, it is usualy formed from the SQL syntax, usualy the difference is restricted to the use of buildin functions like
COUNT or
LIMIT
Quote:
Originally posted by rmill9681
3. What is sqlplus?
|
If I remember correct, the sqlplus is a set of classes with which you can talk to the Oracle database from a C++ program, where you would create an environment and within this, the text strings are treated as if you were sending the commands directly to the database.
Or perhaps my memory is fading, it's been nearly 4 years since I've used it.