1> how are u debugging in plsql ?
2> how to connect oracle database from unix. is there ne
way other than using sqlplus ?
Answers were Sorted based on User's Feedback
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.
|Is This Answer Correct ?||0 Yes||1 No|
Answer / guru
hi friends click below link to see Debugging in Plsql
|Is This Answer Correct ?||1 Yes||2 No|
Can a primary key be a foreign key?
What is use of package in pl sql?
What do you mean by field in sql?
Is it important to partition hard disk?
what is log shipping? : Sql dba
What are literals in sql server?
Are stored procedures compiled?
what is variable in package specification
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.
What is a stored procedure in sql with example?
What is the default value of CHAR type?
- 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?