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 are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

783

---

What is AUTH_ID and AUTH_USER in pl/sql ?

1970

---

What is fmtonly in sql?

754

---

What are the two types of exceptions.

872

---

How do you modify a column in sql?

773

---

which operator is used in query for pattern matching? : Sql dba

794

---

How do I truncate a sql log file?

791

---

How to convert comma separated string to array in pl/sql?

880

---

How do I run sql?

861

---

How to add a column ‘salary’ to a table employee_details?

807

---

What do you mean by stored procedures?

782

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

797

---

What is a temp table?

774

---

Define select, insert, create, delete, update, drop keywords

810

---

Can we use distinct and group by together?

817

---