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
What is dirty read and phantom read?
What is sql vs mysql?
What is memory table?
What is difference between group by and order by clause?
What are ddl statements in mysql?
How do I check mysql version?
What is append query?
How can you retrieve a particular number of records from a table?
How to get the number of rows selected or affected by a sql statement?
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.
What is the difference between is null & is not null?
Is mysql a nosql database?
What is blob in mysql?
Can mysql store files?
What is pragma serially_reusable and why is it used?