After update how do u know how many records got updated
Answer Posted / pkd
Except sql%rowcount,using returning clause with count()
function
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Give the advantages and disadvantages of clusters.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What are advantages of dateset in datastage?
What is a package ? What are the advantages of package ?
What happens to the current transaction if the session is ended?
How to define an anonymous procedure without variables?
What is set operator oracle?
How to divide query output into groups in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are operators in oracle?
Explain temporal data types in oracle
How can we find out the current date and time in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How would you begin to troubleshoot an ORA-3113 error?
What is primefaces used for?