Answer / gourvendra singh

1> we can do the debugging in the plsql by placing the
message in the code, so that we can trace the values and
pointer in the pl/sql.

Answer / guru

hi friends click below link to see Debugging in Plsql

http://www.adp-gmbh.ch/ora/plsql/debug.html#dbr

Can a primary key be a foreign key?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

What do you mean by field in sql?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

what is log shipping? : Sql dba

0 Answers  

---

---

What are literals in sql server?

0 Answers  

---

Are stored procedures compiled?

0 Answers  

---

what is variable in package specification

2 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is a stored procedure in sql with example?

0 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---