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

How many clustered indexes can be created on a table?

1122

---

What are aggregate functions in sql?

1225

---

Can we create a trigger on view?

946

---

How do I turn a list into a table?

1010

---

What is oracle sql developer?

1118

---

Is postgresql a server?

1112

---

Can a trigger call a stored procedure?

1127

---

What are operators available in sql?

1095

---

Is sql a backend?

1073

---

What are the datatypes available in pl/sql ?

1151

---

how can we submit a form without a submit button? : Sql dba

1036

---

What is sap sql?

1030

---

Explain what is dbms?

1120

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1064

---

What does bitemporal mean?

1115

---