Answer Posted / sangeetha

create or replace procedure <pocedure_name>(x in number,y
out varchar) is begin
{
executable statements;

}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);

Write a unique difference between a function and a stored procedure.

925

---

What is composite primary key in sql?

939

---

What is java sql drivermanager?

1020

---

How does postgresql compare to "nosql"?

981

---

what are tables and fields? : Sql dba

988

---

how to convert character strings to numeric values? : Sql dba

1024

---

what is timestamp in mysql? : Sql dba

1002

---

what is error ora-03113: end-of-file on communication channel?

1081

---

Can we use delete in merge statement?

1000

---

What is dml and ddl?

899

---

What is localdb mssqllocaldb?

1017

---

Write a query to display the current date in sql?

967

---

what is heap table? : Sql dba

1047

---

What is sqlite format?

1108

---

What is a pl/sql block?

1111

---