Answer Posted / prativa mishra

Yes, this package will execute.
example:- suppose we have create a package inside any user
create or replace package sn_pck is
procedure sn_pr(c out number);
end;

create or replace package body scn_pck is
procedure sn_pr(c out number) is
begin
select b into c from sn where name='sony';
DBMS_OUTPUT.PUT_LINE(C);
END;
END;

after that you shd connect hr user
and execute that package it execute 100%

how u will execute on hr user:-

declare
e number;
begin
prativa.sn_pck(e);
end;

note:- here i hv created that package in a user named prativa
and in user i hv create a table sn

Is it important to partition hard disk?

1024

---

What is the maximum number of columns in sql table?

1172

---

What is the difference between the sql*loader and import utilities? : aql loader

1043

---

Inline the values in PL/SQL, what does it mean.?

1228

---

Can we use ddl statements in stored procedure sql server?

1011

---

how to use like conditions? : Sql dba

1110

---

how do you control the max size of a heap table? : Sql dba

980

---

What are the types of queries in sql?

1086

---

What is mutating sql table?

1112

---

What is procedure explain with example?

962

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1829

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

What is the need of merge statement?

1038

---

how to use regular expression in pattern match conditions? : Sql dba

1031

---

Is big data nosql?

949

---