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);

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1135

---

Is sql a programming?

940

---

Why are cursors used?

1069

---

How many sql databases can you have on one server?

1027

---

What is int identity in sql?

1071

---

What is trigger in pl sql with examples?

990

---

What do you understand by case manipulation functions?

957

---

What are the steps for performance tuning.

1282

---

What are the benefits of triggers?

1127

---

How do I run a sql query in pgadmin 4?

911

---

what are the differences between binary and varbinary? : Sql dba

988

---

How do I install sql?

946

---

What is nvarchar max in sql?

966

---

what are different types of collation sensitivity? : Sql dba

1034

---

List and explain the different types of join clauses supported in ansi-standard sql?

1310

---