Answer Posted / anil

I assume this question as:
") I have 2 programs  A and B. Now program A references Program  B and Program B references Program A. How do you compile such inter-dependent objects in PL/SQL"

ANS:We can compile mutually referencing programmes using FORWARD declaration(specifying the declaration of one program in beginning of package body) inside a PACKAGE.
Example:
CREATE OR REPLACE PACKAGE test_pack
IS
gvar NUMBER:=0;
--PROCEDURE p1; --we can also achieve like this
END;
/

CREATE OR REPLACE PACKAGE BODY test_pack
IS
PROCEDURE p1; --forward declaration

PROCEDURE p2 
IS
BEGIN
P1;
END;

PROCEDURE p1
IS
BEGIN
p2;
END;

END;

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

1537

---

Can dml statements be used in pl/sql?

1021

---

What is the use of partition by in sql?

931

---

Explain the uses of a database trigger?

985

---

Explain aggregate functions are available there in sql?

943

---

What is rank dense_rank and partition in sql?

976

---

What are sql indexes?

938

---

What is exception? What are the types of exceptions?

1034

---

What is sql and explain its components?

1009

---

Define commit, rollback and savepoint?

979

---

What is coalesce sql?

943

---

What is update query?

922

---

Explain the difference between sql and mysql.

1003

---

how to get help information from the server? : Sql dba

877

---

What is left join in postgresql?

998

---