If a column is an image value type, how you can compare column values? How can you use this column in join clause?
951You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
1008You 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?
923The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
951What are the three basic rules which are to be followed for the relational model of the database?
940Post New DB Development Questions
What is dbms and its application?
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?
Explain about the database management systems.
How to replace not in with not exist?
Why does this query return 0?
Can an extended stored procedure be called from inside a user-defined function?
What are the three basic rules which are to be followed for the relational model of the database?
What are data modelling techniques?
How can you fix a poorly performing query?
How to read and create .LDC data files which are used by linguatic dictionary.
How you can make a parameterized view?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
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?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
In which table collections errors are stored.