Interested to Buy Any Domain ? << Click Here >> for more details...
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
- 1 Answers
- 3126 Views
- TCS, I also Faced
- E-Mail Answers
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
| Is This Answer Correct ? | 1 Yes | 0 No |
What is phantom read in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is consistency token
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is dbrm? What it contains?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is cursor stability in db2?
Normalization in DB2 – first normal form, second normal form
What are foreign keys in db2?
what's the best lock size that you could use when you create a tablespace?
COBOL 
