Answer / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

What is the largest value that can be stored in a byte data field?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What is Overloading of procedures ?

2 Answers  

---

What is partition in sql query?

0 Answers  

---

describe mysql connection using mysql binary. : Sql dba

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

Explain how to use transactions efficiently : transact sql

0 Answers  

---

What is sql character function?

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

What is an alias command?

0 Answers  

---

Do view contain data?

6 Answers   Ramco,

---

What is trigger explain with example?

0 Answers  

---