Home » SQL & PL/SQL » SQL & PL/SQL » Difference Between SQL & PLSQL (Linux and Oracle 10g)
Difference Between SQL & PLSQL [message #338211] Mon, 04 August 2008 03:48 Go to next message
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
Member
What are the major difference between SQL and PLSQL

[Updated on: Mon, 04 August 2008 03:49]

Report message to a moderator

Re: Difference Between SQL & PLSQL [message #338214 is a reply to message #338211] Mon, 04 August 2008 03:49 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
They are something completely different.

SQL is for queries, PL/SQL is for procedural code.
Re: Difference Between SQL & PLSQL [message #338215 is a reply to message #338214] Mon, 04 August 2008 03:56 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
PL/SQL is the procedural extension of SQL.

SQL is used to query the relational database.

You use PL/SQL when you want to do something like
IF Else,Loops

Regards,
Rajat
Re: Difference Between SQL & PLSQL [message #338216 is a reply to message #338211] Mon, 04 August 2008 03:56 Go to previous messageGo to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

Please go through the given below link,

http://orafaq.com/faq/sql_and_pl_sql

Best regards,
Aravindh
Re: Difference Between SQL & PLSQL [message #338217 is a reply to message #338211] Mon, 04 August 2008 03:56 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference

Regards
Michel
Previous Topic: Slow querie with union all
Next Topic: raise_application_error message
Goto Forum:
  


Current Time: Thu Dec 08 16:36:41 CST 2016

Total time taken to generate the page: 0.05564 seconds