Answer Posted / sanjay

Create Or Replace Procedure Test(p_Var1 In Number)
As
v_Var1 Number;
Begin
v_Var1 := p_Var1;
Dbms_Output.Put_Line(v_Var1);
Exception
When Others Then
Dbms_Output.Put_Line(Sqlerrm(Sqlcode));
End Test;
/

Explain a segment?

1033

---

What is the relation of a user account and a schema in oracle?

1015

---

What is a subquery in oracle?

1050

---

What is define in oracle?

1016

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1963

---

Does facebook use oracle?

990

---

What is the data pump import utility?

979

---

How to export data with a field delimiter?

980

---

How to pass parameters to procedures in oracle?

1002

---

How can windows applications connect to oracle servers?

997

---

How to open a cursor variable?

982

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1962

---

What is connection pool in oracle?

935

---

How do I connect to oracle database?

1033

---

How does one get the view definition of fixed views/tables?

974

---