Answer Posted / vipin kumar (m.c.a)

For calling both have the different method--
To call function

variablename:=functionname(arguments);

To call procedure

procedurename(argumentlist);

What is having clause in sql?

527

---

How to return an array from java to pl/sql?

587

---

Why procedure is used in sql?

531

---

How to run sql*plus commands in sql developer?

589

---

What is offset in sql query?

593

---

---

What are the parameter modes supported by pl/sql?

532

---

How do I add a database to sql?

576

---

What do you mean by dbms? What are its different types?

552

---

Explain the working of primary key?

606

---

How is a PL/SQL code compiled?

666

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

644

---

what are numeric data types? : Sql dba

576

---

How do you get column names only for a table (sql server)?

663

---

What are transaction and its controls?

559

---

How many sql are there?

510

---