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

Is oracle a language?

934

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1037

---

How many data types are supported?

1077

---

What is the difference between sharding and replication?

1033

---

How to assign a tablespace to a users in oracle?

1045

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2450

---

How do we represent comments in oracle?

1042

---

What is pragma autonomous transaction in oracle?

1058

---

Why does oracle 9i treat an empty string as null?

1041

---

Can we protect our pl/sql source code?

1038

---

List the various oracle database objects?

1049

---

How to drop an existing table in oracle?

1055

---

What is the data pump export utility?

1077

---

How to drop a stored function?

1134

---

Can a parameter be passed to a cursor?

1113

---