1. What do you mean by how many keeps used in xped? Is it how many keeps 'one can do'? I guess as many as the declarative variables present.
2. This question is asked to check is if one knows the 'for' clause used in the cursors. If the cursor is declared with *no* 'for' clause, the cursor is closed automatically with *no* explicit closing of that cursor when the commit is issued. Else, the cursor is *not* closed.
1. What do you mean by how many keeps used in xped? Is it how many keeps 'one can do'? I guess as many as the declarative variables present.
2. This question is asked to check is if one knows the 'for' clause used in the cursors. If the cursor is declared with *no* 'for' clause, the cursor is closed automatically with *no* explicit closing of that cursor when the commit is issued. Else, the cursor is *not* closed.
Please avoid using special symbols, they may mis-lead.......
I'm sorry I've to correct what I answered earlier.
2. This question is asked to check is if one knows the 'with hold' clause used in the cursors. If the cursor is declared with no 'with hold' clause, the cursor is closed automatically with 'with hold' explicit closing of that cursor when the commit is issued. Else, the cursor is not closed.