What will you get by the cursor attribute sql%rowcount?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,


what is meant by forward declaration in functions?

4 Answers   TCS,


What is the difference between inner join and outer join?

0 Answers  


write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,


Does sql full backup truncate logs?

0 Answers  






i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,


what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  


in a package one procedure is wrong package shows valid or not

4 Answers  


What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,


What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  


Do foreign keys improve performance?

0 Answers  


write a procedure to find top second no from a list of numbers

1 Answers   ABC,


Categories