Answer Posted / madhuri

SHOW ERROR will show the error code and message in a pl/sql
block.

If you know where exactly the error is then uses number of
dbms statements before/after each sql statement.

Can you sum a count in sql?

1010

---

How do I view a sql database?

1019

---

What does the hierarchical profiler does?

1058

---

Which command is used to call a stored procedure?

1000

---

Show code of a cursor for loop.

1053

---

What is pl sql quora?

1147

---

Can you have a foreign key without a primary key?

953

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1636

---

Are stored procedures faster than dynamic sql?

1033

---

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..

2496

---

Explain the methods used to protect source code of pl/sql.

1017

---

what is innodb? : Sql dba

1099

---

How can you select unique records from a table?

1074

---

What are types of indexes in sql?

1080

---

What is a .db file?

984

---