Answer Posted / rajesh.k

sql is a structure query language,in which we are retriving
the data through statements from the database,it cannot be
used for later application,,,
pl/sql is a programming language it has the
declare
variables;
begin
sql smts;
exceptions
end;
in plsql thru stored programs like proc,func we can use for
later applications,,

Can we use insert statement in function?

1001

---

What are the advantages of normalization?

1078

---

Can we call stored procedure in function?

958

---

What is the difference between unique and primary key constraints?

1071

---

Explian rowid, rownum? What are the psoducolumns we have?

1001

---

What are pl sql procedures?

1024

---

what is a primary key? : Sql dba

1033

---

What are the constraints available in sql?

1047

---

Name the operator which is used in the query for pattern matching?

946

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1068

---

Is left join inner or outer?

1014

---

Does sql use python?

1030

---

what is meant by nl2br()? : Sql dba

1044

---

what are local and global variables and their differences? : Sql dba

1070

---

What is the difference between partitioning and sharding?

1008

---