package specification-3 procedures
package body-2 procedures will is execute
Answers were Sorted based on User's Feedback
Answer / umesh joshi
Package specification can be compiled without compiling
package body, whereas package body cannot be compile
without specification compilation
|Is This Answer Correct ?||21 Yes||0 No|
Answer / ajexpert
Package body should contain the same number and type of
objects as declared in package specification
|Is This Answer Correct ?||11 Yes||11 No|
what are all different types of collation sensitivity? : Sql dba
What is the purpose of cursors in pl/sql?
how view used for security purposes?
How do you modify a trigger?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
a procedure one in two out parameters i am waiting it in a sql query can i get the output
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
Is sql harder than python?
Which is faster count (*) or count 1?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
What is sorting in sql?