query language differences

greenspun.com : LUSENET : OpenKnowledge : One Thread

Is the query language the same for sql server 2000 and oracle? What is the difference between pl/sql and sql?

-- Sukhbir Singh (Brownsugar773328@hotmail.com), March 18, 2003


plsql is a proprietary language coined by oracle for use with their databases. Sql (structured query language) by itself isn't really a programming language. Is is more like a data sublanguage. You need to combine sql with some other programming language (like C, Visual Basic, or Java) to create a complete application. This is essentially what oracle did. plsql combines sql with procedural programming language. In answer to your first question, you can use sql with any database. I have used the following databases oracle, informix, MS access, and SQL server and found that with each database the sql syntax is slightly different. If you learn sql though it will be fairly easy to navigate between the syntax changes. Try a book like SQl for dummies. I use it even now as a reference.

-- Kikuyu Daniels (kikuyu_matthews@alum.mit.edu), October 17, 2003.

Oracle is using PL/SQL(Procedural language). It is a combination of Procedural language and simple SQL Statements.More clearly saying, PL/SQL can be written in such a way that, you can use conditional SQL statements as well as procedural language (Procedural language can be written in C). T-SQL(Transact SQL) is using in SQLServer 2000 and it is not so flexible like PL/SQL. You can refer OReilly's PL/SQL book as a reference. Thank You

-- Liju Thomas (lijuthomas_80@yahoo.co.uk), November 30, 2004.

no, they have differ. sql server have "TSQL" while oracle have "PL\SQL". both r the procesdurel lang. to communicate with databases and front_end applications. "SQL" is a 'ANSI standard" for retriving data from database/back_end. any procedurel lang. uses "SQL" for that purpose. so offcourse SQL_SERVER and ORACLE also.

with good regards

-- MAYANK MANI DUBEY (rumayank@yahoo.com), January 06, 2005.

Moderation questions? read the FAQ