what is the difrence between sql and pl/sql
Answer Posted / dinesh joshi
1)SQL is executed one statement at a time. PL/SQL is
executed as a block of code.
2)SQL tells the database what to do (declarative), not how
to do it. In contrast, PL/SQL tell the database how to do
things (procedural).
3)SQL is used to code queries, DML and DDL statements.
PL/SQL is used to code program blocks, triggers, functions,
procedures and packages.
4)You can embed SQL in a PL/SQL program, but you cannot
embed PL/SQL within a SQL statement.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How many ways to get the current time?
Can not connect to mysql server 10060?
How do I enable mysqli extension?
How to get a list of indexes of an existing table?
How to escape special characters in sql statements?
What is data types in mysql?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
How do I start mysql server?
what is database black box testing? : Mysql dba
How do I copy a table in mysql?
What is mysql and how it works?
List data types in mysql? Explain
What is a csv table?
How do I download mysql on my laptop?
What is mysql and why it is used?