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

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Is a view faster than a stored procedure?

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Why stored procedures are faster than query?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

What is indexing oracle sql?

0 Answers  

---

Why we use joins in sql?

0 Answers  

---

Explain ddl statements in pl/sql?

0 Answers  

---