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.

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

How many types of functions are there in sql?

0 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

What is difference between my sql and sql?

0 Answers  

---

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

Determine if oracle date is on a weekend?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

Does asenumerable execute the query?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

Is sql a programming?

0 Answers  

---