Answer / rajesh

The package procedure and function are called by using
package name.function/procedure name....

Answer / madhavi

If A function returns only one value then u can call
that function from select statement like
select packagename.functionname(parameters) from dual,


But for procedure its not possible to call through select
statement u have to call through anonymous block.
declare
begin
packagename.procedurename(actual parameters);
end;
/

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

Is sql between inclusive?

0 Answers  

---

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What is java sql driver?

0 Answers  

---

How do you modify a column in sql?

0 Answers  

---

What is sql analyzer?

0 Answers  

---

How do you create a db file?

0 Answers  

---

What is the basic form of sql query?

0 Answers  

---

Can a table have no primary key?

0 Answers  

---

what is self join and why is it required? : Sql dba

1 Answers  

---