Answer Posted / antu

SQL is a data oriented language for selecting and
manipulating sets of data. PL/SQL is a procedural language
to create applications. You don't normally have a "SQL
application". You normally have an application that uses SQL
and a relational database on the back-end. PL/SQL can be the
application language just like Java or PHP can. SQL may be
the source of data for your screens, web pages and reports.
PL/SQL might be the language you use to build, format and
display those screens, web pages and reports.

Think of it like this: The code that makes your program
function is PL/SQL. The code that manipulates the data is
SQL DML. The code that creates stored database objects is
SQL DDL. DDL compiles the code that is written in PL/SQL.
PL/SQL may call SQL to perform data manipulation. The
commands that format the output of a tool are not related to
the SQL standard or to PL/SQL.

What do you mean by % and _ in the LIKE statement?

985

---

What are the functions used to encrypt and decrypt the data present in mysql?

1107

---

Can you tell the difference between ereg_replace() and eregi_replace()?

1035

---

How many columns can a mysql table have?

908

---

Is mariadb faster than mysql?

964

---

What is difference between mysql_connect and mysql_pconnect?

1041

---

How big is a blob mysql?

892

---

What does "i_am_a_dummy flag" do in mysql?

959

---

How to get last inserted id after insert data from a table in mysql?

982

---

What is pdo in mysql?

933

---

What is a mysql view?

840

---

Does mysql use tcp or udp?

919

---

Is null in mysql?

869

---

What are the 5 r's of managing behaviors?

1088

---

How to show all tables with 'mysql'?

1005

---