Pgm A calls Pgm B and pgm B uses cursor, when pgm B is
called second time, the program is abending saying the
cursor is opened? Why?
No Answer is Posted For this Question
Be the First to Post Answer
Explain about relational database management systems?
Explain about the hierarchical model of the database?
Explain the role of indexing in databases?
What is a join and explain different types of joins?
What are the types of database model?
Explain about the database management systems.
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How is data stored in dbms?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the key features of dbms?
Which data type cannot be used as a parameter in a udf?
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)