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

How to empty your oracle recycle bin?

1021

---

What are the components of logical database structure in oracle database?

1088

---

How do I learn what codesets are available in oracle?

1038

---

How to login to the server without an instance?

1162

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

---

What happens to the data files if a tablespace is dropped?

1059

---

How can you use check constraints for self referential integrity?

969

---

What is an index associated with a constraint?

1040

---

Explain an index?

1134

---

What is the usage of save points in oracle database?

964

---

What is archive log in Oracle?

1134

---

What are the limitations of check constraint?

1033

---

How to see the table columns used in an index?

1024

---

What is index-organized table in Oracle?

1069

---

Can you assign multiple query result rows to a variable?

987

---