Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (43.6k points)

Could someone explain the difference between PL/SQL and SQL?

1 Answer

0 votes
by (97.5k points)

Let me explain the difference between PL/SQL and SQL:

  • SQL or Structured Query Language is a data-oriented language whereas PL/SQL or Procedural Language extension to SQL is an application-oriented language.
  • SQL is used to create, maintain, and retrieve RDB or Relational database. Whereas PL/SQL is used for providing SQL with procedural capabilities.
  • SQL works directly with the database server whereas PL/SQL doesn’t interact directly with the database server.
  • SQL could only execute single operation at a time, whereas PL/SQL could execute multiple operations.
  • SQL could be embedded inside PL/SQL block, whereas PL/SQL couldn’t be embedded inside SQL code.

Want to know more and become an expert? Check out Intellipaat’s SQL course which offers you an online training course and guided projects to help you gain  practical experience.

Also, check out our video on PL/SQL Interview Questions and Answers - For Freshers and Experienced, to get more insights.

Related questions

0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)
0 votes
1 answer
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (43.6k points)
0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)
0 votes
1 answer
asked Oct 20, 2020 in SQL by dev_sk2311 (43.6k points)

Browse Categories

...