Answer Posted / susila

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

}
end <procedure_name>;

exec <procedure_name>(10,y);

What is the max nvarchar size?

982

---

Can we use insert statement in function?

1003

---

What are the benefits of pl sql?

1121

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2084

---

how to calculate expressions with sql statements? : Sql dba

1034

---

Which is better varchar or nvarchar?

997

---

What is the best sql course?

985

---

What do you mean by table in sql?

991

---

What are operators available in sql?

1048

---

Can we use views in stored procedure?

1034

---

what are date and time functions in mysql? : Sql dba

979

---

what is “go” in t-sql? : Transact sql

1105

---

What does the acronym acid stand for in database management?

1032

---

What are transaction and its controls?

1040

---

How can a pl sql block be executed?

948

---