what is difference b/w pravite procedures and public
Answers were Sorted based on User's Feedback
Answer / a g srikanth
Any procedure that is declared and defined ONLY in the
package body is a private procedure. This procedure is
local to the package and other procs cannot call any
On the other hand if the procedure is defined in the
package specification and defined in the package body it is
a public procedure, this is accessible to other procs also.
|Is This Answer Correct ?||29 Yes||1 No|
Answer / siva
If the procedure is with in the package it is the public
procedure,other wise it is private procedure.
|Is This Answer Correct ?||18 Yes||8 No|
Answer / swati sucharita
private procedure is used before class name.if we have
declared private before class name then subclass cannot
inherit the properties of private class.
public procedure is used before class name,if we have
declared public before class name then all other class can
inherit the properties of public class.
|Is This Answer Correct ?||3 Yes||5 No|
Explain the savepoint statement.
what is bcp? When does it used? : Sql dba
Why schema is used in sql?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?
What is pl sql record in oracle?
What is application trigger?
What is the difference between delete, truncate and drop command?
What is lexical units in pl sql?
What is a full join?
how to use case expression? : Sql dba
What is Difference Between delete and Truncate?