Answer / a.jyothsna

We can write any no.of procedures in a package

Answer / rahul khanke

yes u can write number of procedure in a package
bcoz package is collectin of stored procedure and function.

the idea is-- it is an box(package) where all the material
(procedure and function) is stored.

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

What is cartesian join in sql?

0 Answers  

---

What is a crud api?

0 Answers  

---

What are all the different types of indexes?

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

how to select unique records from a table? : Sql dba

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---