Interested to Buy Any Domain ? << Click Here >> for more details...
After update how do u know how many records got updated
- 4 Answers
- 8415 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / svj
Using SQL Cursor Attribute,'SQL%ROWCOUNT' which gives
no.of rows affected by the most recentSQL statement (an
integer value), one can know no.of records got updated.
For Example :
VARIABLE rows_updated VARCHAR(30)
DECALRE
v_dept_no departments.department_id%TYPE := 20
BEGIN
UPDATE employees
SET salary = salary + 1000
WHERE department_id = v_dept_no;
: rows_updated := (SQL%ROWCOUNT || 'rows updated.');
END;
/
PRINT rows_updated
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / pkd
Except sql%rowcount,using returning clause with count()
function
| Is This Answer Correct ? | 1 Yes | 1 No |
List the parts of a database trigger.
How to enter a new row into a table interactively?
interview questions with answer for cts
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
Respected sir, Please send me technical questions related to oracle apps..
How to create a table index?
without using count(*) and rownum how can we count total record in a table
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
various types of hints and their usage
What is save point in oracle database?
what are archived logs?
Oracle General 
