What is the difference between nvl and coalesce?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the contention situations caused by locks?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is a data page?
How can you quickly find out the # of rows updated after an update statement?
How can we read records for specific member in CL? AND rpg?
What's The Percentage Free Space ?
What is ALTER ?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is an access path?
How to handle null values in db2
What do you mean by storage group (stogroup)?