What will you get by the cursor attribute sql%rowcount?
No Answer is Posted For this Question
Be the First to Post Answer
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??????
what is meant by forward declaration in functions?
What is the difference between inner join and outer join?
write a query find which rows of a table is updated on 2 days before?
Does sql full backup truncate logs?
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
in a package one procedure is wrong package shows valid or not
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What is an exception in PL/SQL? What are the two types of exceptions?
Do foreign keys improve performance?
write a procedure to find top second no from a list of numbers