what is the difrence between sql and pl/sql

Answer Posted / kalyana chakravarthy

SQL is structured query language which is used to retrive
data from the database. Before 1974 it is known as Gupta
SQL. In 1974 Relational solutions Inc(Now oracle
corporation) taken it as a native lang to retrive data.
Though it is structured quer language it is un structured
its like simple english language.

Pl/Sql is an extension for Sql. It is a structured 4th
generation language where one can execute more than one
select statement with conditional constructs like if, then
and else.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dirty read and phantom read?

443


What is sql vs mysql?

522


What is memory table?

498


What is difference between group by and order by clause?

542


What are ddl statements in mysql?

542






How do I check mysql version?

489


What is append query?

512


How can you retrieve a particular number of records from a table?

499


How to get the number of rows selected or affected by a sql statement?

509


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3440


What is the difference between is null & is not null?

520


Is mysql a nosql database?

509


What is blob in mysql?

497


Can mysql store files?

496


What is pragma serially_reusable and why is it used?

477