Differences between languages

doublehelix2 · 11 Jun 2008 at 18:19

What are the major differences between database languages (sql, oracle) and C++/java?

I know they are used for different things, but structurally how are they different?

sparkey196 · 11 Jun 2008 at 18:59

If you are really interested, why not take some time to some research yourself?

http://en.wikipedia.org/wiki/Comparison_of_Java_and_C++

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

rpstewart · 11 Jun 2008 at 19:13

doublehelix2 said:
What are the major differences between database languages (sql, oracle) and C++/java?

You can't really compare SQL and any of the traditional programming languages. For example it's not possible to create a standalone program in SQL, it will only run within the confines of a database server and then only on one which contains a database with the correct structure.

Una · 11 Jun 2008 at 21:06

Basically SQL is a declarative query language, its not turing complete either... Where C++/Java are Imperative and are. Syntactically and Semantically SQL is very different from C++/Java.

In theory I suppose you could create a standalone program in SQL if you wrote a compiler/interpreter for it... :| Though you would have to extend the base language to support some constructs (Like hmm, T-SQL/P-SQL which are turing complete).

meghatronic · 11 Jun 2008 at 23:59

Una said:
Basically SQL is a declarative query language, its not turing complete either... Where C++/Java are Imperative and are. Syntactically and Semantically SQL is very different from C++/Java.

In theory I suppose you could create a standalone program in SQL if you wrote a compiler/interpreter for it... :| Though you would have to extend the base language to support some constructs (Like hmm, T-SQL/P-SQL which are turing complete).

^ perfect post.

doublehelix2 · 12 Jun 2008 at 00:35

Just what I wanted, thanks. I didn't know how to describe what I actually meant, but you nailed it.