Answer Posted / subhendu

Functions called from SQL have special restrictions:

Accept only IN parameters
cannot contain DML
cannot contain DDL - implies COMMIT
Accept and return only SQL datatypes (not PL/SQL
specific datatypes)
Must use positional notation
Must own or have EXECUTE privilege
Cannot contain transactional or session control
statements (eg. COMMIT, ROLLBACK, ALTER)

What is the usage of nvl function?

598

---

Which sql statement is used to delete data from a database?

467

---

what is oltp (online transaction processing)? : Sql dba

536

---

How to call shell script from pl sql procedure?

625

---

Which sql statement is used to return only different values?

506

---

---

What is difference between rank () row_number () and dense_rank () in sql?

581

---

what is 'mysqld'? : Sql dba

546

---

Can we update views in sql?

535

---

What is procedure explain with program?

554

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

572

---

What is the location of pre_defined_functions.

646

---

Why stored procedures are faster than query?

570

---

What are the operators used in select statements?

578

---

Is sql free?

501

---

how to return query output in html format? : Sql dba

651

---