Answer Posted / useroracle

Global variable or subprogram(procedure,function) that can
be referenced outside the package and is visible to
external users user is called global variable. Global
package items must be declared in the package specification.

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2491

---

Why do we use function in pl sql?

1058

---

What is the requirement of self-join?

1119

---

What is rtm stands for?

1093

---

Which table is left in left join?

1010

---

What is rank dense_rank and partition in sql?

1025

---

describe mysql connection using mysql binary. : Sql dba

1059

---

What is composite data type in pl sql?

1098

---

what are different types of keys in sql?

1143

---

what is sql in mysql? : Sql dba

1185

---

can sql servers linked to other servers like oracle? : Sql dba

1005

---

What language is oracle sql developer?

1002

---

Which table is left in join?

974

---

What are the operators in sql?

1023

---

tell me about various levels of constraint. : Sql dba

1031

---