difference in syntax between Oracle PL/sql and SQL 2005

Question

0.00/5 (No votes)

See more:

SQL

I am very new to pl sql.Is there any difference in syntax between Oracle PL/sql and SQL 2005 server?

Posted 23-Jul-12 21:22pm

Prashant Bangaluru

Add a Solution

Comments

StianSandberg 24-Jul-12 3:29am

There are a lot of differences between t-sql and pl/sql. Some of them can be found here: http://www.knowdotnet.com/articles/plsql_tsql.html The rest you'll find on google.

Prashant Bangaluru 24-Jul-12 8:14am

Thanks for suggesting that link.It cleared my question Thanks to both.

4 solutions

Solution 1

Read the following :

http://stackoverflow.com/questions/290829/differences-between-sql-and-pl-sql[^]

http://it.toolbox.com/blogs/oracle-guide/what-is-the-difference-between-oracle-sql-and-plsql-9602[^]

Posted 23-Jul-12 21:31pm

Mehdi Gholam

Solution 2

Definitely, both products provide special features accesible through extensions to SQL. For regular selects, inserts and updates you are not likely to encounter those differences.

Best regards
Espen Harlinn

Posted 23-Jul-12 21:32pm

Espen Harlinn

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Philip Stuyck · Accepted Answer · 2012-07-23T21:34:00

Sql Server uses T-SQL and Oracle uses PL/SQL.
PL-SQL uses packages which is a concept that does not exist in SQL server.
Actually when you have a piece of code in SQL server for a stored procedure, the chance is rather high that it is not directly portable to oracle and vice versa except perhaps for very simple cases.
So the simple answer to your question is yes, there are a lot of syntax differences between oracle pl/sql and sql server. There might be a standard to define and standarise SQL, but there is no such standard when it comes to programming stored procedures.

Bernhard Hiller · Accepted Answer · 2012-07-24T00:08:00

SQL stands for Structured Query Language, not Standard Query Language. Most simple things wotk the same way on Microsoft SQL Server and Oracle. The more complicated the queries become, the more likely you'll face the differences.
And also some data types do not exist on both servers: Oracle does not know Guid. And automatic creation of ID values must be done with triggers and sequences in Oracle.

difference in syntax between Oracle PL/sql and SQL 2005

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0