What is cursor and why it is required?
No Answer is Posted For this Question
Be the First to Post Answer
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What is dynamic sql in pl sql?
what is constraining table?
What is Difference Between delete and Truncate?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
What is set serveroutput on in pl sql?
What is the use of %rowtype?
What is a dirty read sql?
What are different types of functions in sql?
what is a join? : Sql dba
What is package in pl sql?
What are different clauses used in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)