Answer / srinu

U r correct Chandan.But one thing,what is that is if the
table contains some data at that time syntax for adding new
column to that table with notnull constraint is....

alter table table_name add column_name datatype default
value constraint constraint_name not null;

if we want 2 know which columns have which constraints then
the syntax is

select column_name,constraint_type
from user_cons_columns
where table_name='EMP';

Answer / chandan kumar

If table is empty (means no records are there) then we can
add the constraint.

alter table tablename add (col_name datatype not null)

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

What does := mean in pl sql?

0 Answers  

---

Is sql developer case sensitive?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

What is a record in a database?

0 Answers  

---

What program will open a mdb file?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

Is sql sequential or random?

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

when normalization is required

3 Answers   HCL,

---

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

1 Answers   Zensar,

---